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

What is a pl/sql block?

1220

what are the differences between require and include, include_once and require_once? : Sql dba

1018

Which are the different types of indexes in sql?

1054

Can we create index on primary key?

961

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1054

What is a join?

1057

How many postgresql users are there, worldwide?

1057

What is join view in sql?

944

How to add, remove, modify users using sql?

1032

What is dml and ddl?

948

What are the benefits of triggers?

1166

What is a clob in sql?

1012

How do I find duplicates in sql?

929

How can get second highest salary in sql?

981

How do you change a value in sql?

1011