Hi ,
in the order by clause if I give column name , I get error . can anybody help pls .
|
0
|
You can also give the column number in the order by clause. Usually column names work within the order by clause but in some cases you have to go with column numbers e.g. when using within the WITH RECURSIVE clause. |
||
|
|
|
0
|
If your query contains a UNION, MINUS, or INTERSECT operator you can not reference the column(s) by name in your ORDER BY clause. |
||
|
|
