SELECT * FROM ( SELECT * FROM Emp ORDER BY ROWNUM DESC ) WHERE ROWNUM

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 / swastik

16 Answers
23163 Views
I also Faced
E-Mail Answers

Answer Posted / swastik

SELECT * FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)
WHERE ROWNUM <= 3;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between where clause and having clause? : Sql dba

947

what is bcp? When does it used? : Sql dba

933

What do you mean by dbms? What are its different types?

950

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7134

How do I edit a trigger in sql developer?

935

What is a memo field?

901

Will truncate release space?

887

How can I make sql query run faster?

960

Why does sql need a server?

988

What is cursor status?

1135

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1014

How do I remove duplicates in two columns?

975

What is record in pl sql?

1009

What is input buffer in sql*plus?

1123

What is meant by truncate in sql?

1004