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

Is primary key clustered or nonclustered?

972


What is ttitle and btitle?

1030


What is a ddl command?

1031


Explain sql data types?

1053


What is the use of index in hive?

982


What is rownum and rowid?

1001


What are some emotional triggers?

946


Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

986


What is the purpose of a secondary key?

923


Is sql a dbms?

951


What is pl sql block structure?

992


what is column? : Sql dba

979


What are inbuilt functions in sql?

1013


Is left join inner or outer by default?

990


Does sql support programming?

1027