if emp table is having 10 records then 1)for first 6 write select enam

how to retrieve last tree records from table?
select *from emp where rownum > (select count(*)-3 from
emp);
i am using this query to get last three records from table
but its not giving any output, so please tell me what is the
error in this query.

Question Posted / ashwin

16 Answers
23682 Views
I also Faced
E-Mail Answers

Answer Posted / ashwin

if emp table is having 10 records then
1)for first 6 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum <7;

2)for last 3 write

select ename,sal from(select ename,sal from emp order by sal
desc) where rownum >7;

Is This Answer Correct ?

2 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an alias command?

1058

Which query operators in sql is used for pattern matching?

957

How do I create a memory optimized filegroup?

959

Explain constraints in sql?

1041

What is the difference between local and global temporary table?

1038

Explain the significance of the & and && operators in pl sql.

1003

What is a sql trace file?

1022

What are the qualities of 2nf?

1035

Is there any restriction on the use of union in embedded sql?

1152

What is sql dialect?

1109

What is the sql query to display the current date?

1039

What are field types?

996

What is sql trigger example?

1049

What is the main difference between sql and pl/sql?

1089

What is schema in sql?

941