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
What are the differences between date and timestamp in oracle?
How to connect asp pages to oracle servers?
How to define an oracle sub procedure?
How to drop a stored procedure in oracle?
What is the difference between PFILE and SPFILE in Oracle?
What do you mean by merge in oracle and how can we merge two tables?
What are the differences between blob and clob in oracle?
How many types of table in Oracle?
Can we create database in oracle using command line ?
query optmization techniques and quwry analyser+projects+ppts
What does sharding mean?
Please explain compound trigger in oracle?
How to drop a tablespace?
what is insert all statement in sql
What is an oracle wallet?