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 loop in pl sql?

769

What are different types of keys?

743

Are sql database names case sensitive?

698

how are mysql timestamps seen to a user? : Sql dba

780

what is subquery? : Sql dba

784

what is oltp (online transaction processing)? : Sql dba

738

Can I join the same table twice?

754

What are inbuilt functions in sql?

796

Can 2 queries be executed simultaneously in a distributed database system?

867

Is sql a backend?

777

What kind of join is join?

708

how to enter numeric values as hex numbers? : Sql dba

778

What are the commands used in sql?

751

What is %type in sql?

704

What is plpgsql language?

719