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

Is it possible to create the following trigger: before or after update trigger for each row?

1289

what is error ora-03113: end-of-file on communication channel?

1166

How do I create a sql database?

1004

What is schema in sql example?

1185

What are aggregate functions in sql?

1166

What are the basic techniques of indexing?

1063

What is rename in sql?

977

What is the purpose of using pl/sql?

1147

What is an exception in pl/sql?

1091

How can I change database name in sql?

1087

How to return an array from java to pl/sql?

1144

What are literals in sql server?

1174

what are the different type of sql's statements ? : Sql dba

926

What will you get by the cursor attribute sql%found?

966

How can we store rows in PL/SQL using array?

1225