View previous topic :: View next topic
|
Author |
Message |
herewego
New User
Joined: 20 Feb 2006 Posts: 14
|
|
|
|
Can we use multiple ORDER BY Clause in a SQL.
Let's consider I have a requirement where I need to sort the data in two different ways based on one of the input field which I will be using in my where condition.
Thanks,
Herewego |
|
Back to top |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Dynamic SQL or else different SQLs for different Inputs .... |
|
Back to top |
|
|
ajeshrn
New User
Joined: 25 Mar 2009 Posts: 78 Location: India
|
|
|
|
Hi,
We can do this through Dynamic SQL.Can some one tell whether this can be done through our Static SQl statements.
Thanks
Ajesh R N |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
No, you can't.
As Ashimer already posted:
Quote: |
Dynamic SQL or else different SQLs for different Inputs .... |
|
|
Back to top |
|
|
|