select distinct TOP3 from emp order by rownum desc;

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 / mohammed shahid

16 Answers
23577 Views
I also Faced
E-Mail Answers

Answer Posted / mohammed shahid

select distinct TOP3 from emp order by rownum desc;

Is This Answer Correct ?

2 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why schema is used in sql?

1032

What is the difference between count 1 and count (*) in a sql query?

969

What information is needed to connect sql*plus an oracle server?

1009

what is sp_pkeys? : Transact sql

1140

How does sql developer connect to oracle database?

986

What is an emotional trigger?

987

what are all the different normalizations? : Sql dba

1017

What does sign mean sql?

1077

Show the cursor attributes of pl/sql.

1031

how to enter characters as hex numbers? : Sql dba

1028

What does cursor do in sql?

1005

How do I add a database to sql?

1111

What are all the ddl commands?

1171

how to run 'mysql' commands from a batch file? : Sql dba

1094

What is sql indexing?

1002