u don't use minum operator to count(*) in subquerry

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

16 Answers
23165 Views
I also Faced
E-Mail Answers

Answer Posted / ramareddy

u don't use minum operator to count(*) in subquerry

Is This Answer Correct ?

4 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does varchar include?

906

What is row_number () in sql?

933

Can two tables have same primary key?

916

What is sql character function?

994

Is hadoop a nosql?

949

Mention what pl/sql package consists of?

938

What is full join?

896

Define union, minus, union all, intersect ?

949

What is rank () in sql?

882

What is the starting oracle error number? What is meant by forward declaration in functions?

938

What is sql entity?

1030

What is the difference between cross join and natural join?

960

Does truncate require commit?

919

What is mutating error in pl sql?

962

how many sql ddl commands are supported by 'mysql'? : Sql dba

955