Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 6681 Views
- I also Faced
- E-Mail Answers
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 is port in oracle? how is it related to database application.
How to turn on or off recycle bin for the instance?
How to store only time; not date and time?
What are data pump export and import modes?
What do database buffers contain?
What to do if dba lost the system password?
What privilege is needed for a user to create views in oracle?
What is the usage of control file in oracle?
How to grant create session privilege to a user in oracle?
How to start a new transaction in oracle?
Explain oracle data types with examples?
What are the different pseudo commands? Explain in general?
Can multiple columns be used in group by in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
How to count groups returned with the group by clause in oracle?
