I have a table emp. There is only one column in the table.
In that , there are only three rows in that column.
The value in the first row is 'A' and the value in the
second row is 'B' and the third row is 'C'. Now, my question
is ,
How will you write a select query to display the output as
B
C
A
Note: order by cannot be used coz it gives us output as CBA.
But the output should be BCA.
Answer Posted / shriram
Garv : Thats right :) Thank you for your answer :)
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain user account with reference to oracle.
How much memory your 10g xe server is using?
How a database is related to tablespaces?
Explain index?
Explain a synonym?
What is a procedure in oracle?
Explain the use of compress option in exp command.
How to delete an existing row from a table in oracle?
What are the restrictions on external table columns?
What is the relationship among database, tablespace and data file?
Which is better Oracle or MS SQL? Why?
What is a directory object?
How to turn on or off recycle bin for the instance?
Why cursor variables are easier to use than cursors?
How to put more than 1000 values into an oracle in clause?