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
- 5718 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 an index associated with a constraint?
What is Virtual Private Database in Oracle?
6. Display the client name and order date for all orders using the traditional method.
What is tns service name?
Explain the truncate in oracle?
What is the purpose of save points in oracle database?
what is the use of system.effective.date variable in oracle?
What is control file used for?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to create a new tablespace in oracle?
What are the ways tablespaces can be managed and how do they differ?
Why do you create or replace procedures rather that drop and recreate.
how to join query for one source type is oracle another source type is sql server ?
Can you assign multiple query result rows to a variable?
How to retrieve data from an explicit cursor?
