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
- 6378 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
How many types of database triggers exist?
What privilege is needed for a user to create indexes in oracle?
what is the difference between functional dependecy and multilevel dependency?
What is a tns service name?
Explain enable novalidate constraint.
How to filter out duplications in the returning rows using oracle?
How to insert multiple rows with one insert statement in oracle?
What is the difference between substr and instr?
How to synchronize 2 schema's objects?
what are actual and formal parameters?
What is a snapshot in oracle database?
Briefly explain what is literal? Give an example where it can be used?
What are the different types of database objects?
How to define an external table with a text file?
What is a trace file and how is it created in oracle?
