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

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

Question Posted / chandrakishan

Answer Posted / chandrakishan

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

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

List and explain the different types of join clauses supported in ansi-standard sql?

1299

what are all the different types of indexes? : Sql dba

995

How can you create an empty table from an existing table?

1009

tell us something about heap tables. : Sql dba

1047

What is the best free sql database?

997

What is pl sql in dbms?

899

What is the most common sql injection tool?

991

What is primary key and unique key?

1044

What is rank () in sql?

878

Explain spool.

1103

How to find 3rd highest salary of an employee from the employee table in sql?

1034

What is foreign key and example?

883

How to write pl sql program in mysql command prompt?

1006

what is self-join? : Sql dba

1050

Differentiate pl/sql and sql?

1010