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

Explain user account with reference to oracle.

954


How much memory your 10g xe server is using?

1084


How a database is related to tablespaces?

1015


Explain index?

1240


Explain a synonym?

1006


What is a procedure in oracle?

1150


Explain the use of compress option in exp command.

998


How to delete an existing row from a table in oracle?

1049


What are the restrictions on external table columns?

1036


What is the relationship among database, tablespace and data file?

964


Which is better Oracle or MS SQL? Why?

6338


What is a directory object?

1068


How to turn on or off recycle bin for the instance?

1048


Why cursor variables are easier to use than cursors?

1064


How to put more than 1000 values into an oracle in clause?

1009