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

Write a query to get last 10 records from the table.

Answer Posted / jprakash025

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

or



SQL> select * from
2 (select rownum a, emp.* from emp)
3 where
4 a>(select max(rownum)-10 from emp);

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the qualities of 2nf?

996


Is not equal in sql?

978


What is a full join?

936


What is sap sql?

947


What is the use of prepared statement?

974


What does where 1 1 mean in sql?

998


Are views faster than queries?

947


What is consistency?

1085


How much does sql cost?

959


What are the parameter modes supported by pl/sql?

1043


What is scope of pl sql developer in future?

980


What is clustered index sql?

963


How to run sql statements through the web interface?

1010


What is sql entity?

1057


What is a function in oracle pl sql?

1005