i have select like this: select

[raji96]

i have select like this:

select studentname,studentid,orderby
from student

and i have order by the select statement based onthe values stored in orderby field,for example if orderby has "studentname,studentid" then i have to sort it by that,how do i do that is there anything like this

select studentname,studentid,orderby
from student
order by &orderby

 

[sem]

The only way to do this is to use dynamic sql.
As for your question, if orderby is the field of student table, how can you sort if the values of orderby are different?