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

How to execute a stored procedure in oracle?

1064


Explain the characteristics of oracle dba?

1101


How to define a cusotmer as a supplier in ORACLE R12

2209


What is the difference between post-database commit and post-form commit?

1161


How will you differentiate between varchar & varchar2?

1026


How to use "if" statements on multiple conditions?

1142


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2235


How to create a new table by selecting rows from another table?

1067


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2146


What is memory advisor in Oracle?

1058


What is a table index?

1071


Explain an index segment?

1092


How do we get field details of a table?

968


How to get execution path reports on query statements?

964


Why do we need integrity constraints in a database?

1001