Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What are the differences between date and timestamp in oracle?

1046


How to connect asp pages to oracle servers?

1072


How to define an oracle sub procedure?

1145


How to drop a stored procedure in oracle?

1051


What is the difference between PFILE and SPFILE in Oracle?

1060


What do you mean by merge in oracle and how can we merge two tables?

1049


What are the differences between blob and clob in oracle?

1089


How many types of table in Oracle?

1122


Can we create database in oracle using command line ?

1085


query optmization techniques and quwry analyser+projects+ppts

2421


What does sharding mean?

1000


Please explain compound trigger in oracle?

1057


How to drop a tablespace?

1043


what is insert all statement in sql

6515


What is an oracle wallet?

942