Mothra
Well-known member
Can you set two fields to order records by?
like this:
ORDER BY fldOne ACS, ORDER BY fldTwo Asc
or something like that?
like this:
ORDER BY fldOne ACS, ORDER BY fldTwo Asc
or something like that?
SQL Statement question...
- Thread starter Mothra
- Start date
Divil
Well-known member
- Joined
- Nov 17, 2002
- Messages
- 2,748
ORDER BY fldOne, fldTWO DESC
etc
etc
dejota6
Member
Yes Mothra you can. I have used that in many cases in some of my code. I will include a sample piece of code that I run all the time
Code:
sql = "Select PR_LNAME, PR_FNAME, PR_MINIT, PR_NUM " _
& "from IGYPRMSD1 order by PR_LNAME asc, PR_FNAME asc;"
Nerseus
Danner
I know in SQL Server you can also ORDER BY ordinal position, such as:
This comes in handy if you have a complex SELECT, such as a CASE statement or subselect.
-ner
Code:
SELECT Field1, Field2 FROM Table1
ORDER BY 1 asc, 2 desc -- or is it 0 asc, 1 desc?This comes in handy if you have a complex SELECT, such as a CASE statement or subselect.
-ner
