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...

Select the Nth lowest value from a table?

Answer Posted / venkat

select * from emp minus select * from emp where rownum <= (select count(*) - &n from emp);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the parameters that we can pass through a stored procedure?

1112


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2312


Explain drop constraint oracle?

1113


Describe an oracle table?

1092


How to write text literals in oracle?

1116


Explain the use of inctype option in exp command.

1079


Why is oracle used?

978


Can a formula column be obtained through a select statement ?

2374


How to create a new table in your schema?

1123


How to connect ms access to oracle servers?

1056


How to define an anonymous procedure with variables?

1235


Can you create a synonym without having a table?

1086


What is a nested table?

1108


What is an Oracle index?

1696


Explain implicit cursor.

1069