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
23805 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

How can use stored procedures in sql?

1144

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1008

Can we create table inside stored procedure?

961

Is id a reserved word in sql?

1151

Explain the working of primary key?

1102

What is normalization? How many normalization forms are there?

1090

How do you bind variables in pl sql?

1104

Cite the differences between execution of triggers and stored procedures?

1082

What is a file delimiter?

1101

Why do we need cursor in pl sql?

1139

What are the three pl sql block types?

1013

what is 'mysqlshow'? : Sql dba

1032

Why procedure is used in sql?

1042

What is sql in oracle?

1068

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4027