note | The entire second parameter is a string and must be enclosed in quotes. Also, note that the vertical bar (|) means “or” in this usage. In this case, you can use either ASC or DESC, but not both. |
TRX_ID PROP_TYPE PROP_XGRID PROP_YGRID TRX_AMT TRX_DATE
1 2BR_HOUSE 1.45096 2.34159 142166.00 04/20/2005 02:00:37
2 3BR_CONDO 1.30454 1.12332 108730.00 05/23/2010 11:06:15
3 4+BR_HOUSE 0.41492 0.67620 273141.00 08/05/1997 06:22:53
4 4+BR_HOUSE 3.52749 0.91387 267949.00 02/25/2010 06:55:33
5 2BR_HOUSE 1.56556 0.46332 193346.00 02/22/1997 12:32:35
6 1BR_HOUSE 2.33187 2.94950 128165.00 04/01/1993 09:46:35
7 4+BR_HOUSE 1.74596 3.32184 229348.00 05/20/2005 00:15:39
8 3BR_HOUSE 4.38503 1.13107 203425.00 07/11/2001 11:17:37
9 4+BR_HOUSE 4.20096 0.90143 376974.00 05/04/1991 23:06:53
10 STUDIO 0.50743 1.31675 39148.00 05/26/1999 19:01:01
prop_trx = ORDER_BY( prop_trx, 'prop_type, trx_date')
TRX_ID PROP_TYPE PROP_XGRID PROP_YGRID TRX_AMT TRX_DATE
6 1BR_HOUSE 2.33187 2.94950 128165.00 04/01/1993 09:46:35
5 2BR_HOUSE 1.56556 0.46332 193346.00 02/22/1997 12:32:35
1 2BR_HOUSE 1.45096 2.34159 142166.00 04/20/2005 02:00:37
2 3BR_CONDO 1.30454 1.12332 108730.00 05/23/2010 11:06:15
8 3BR_HOUSE 4.38503 1.13107 203425.00 07/11/2001 11:17:37
9 4+BR_HOUSE 4.20096 0.90143 376974.00 05/04/1991 23:06:53
3 4+BR_HOUSE 0.41492 0.67620 273141.00 08/05/1997 06:22:53
7 4+BR_HOUSE 1.74596 3.32184 229348.00 05/20/2005 00:15:39
4 4+BR_HOUSE 3.52749 0.91387 267949.00 02/25/2010 06:55:33
10 STUDIO 0.50743 1.31675 39148.00 05/26/1999 19:01:01