Write a query to get last 10 records from the table.
Answers were Sorted based on User's Feedback
Answer / jprakash025
select * from emp
minus
select * from emp
where
rownum<=(select count(*)-10 from emp);
or
SQL> select * from
2 (select rownum a, emp.* from emp)
3 where
4 a>(select max(rownum)-10 from emp);
Is This Answer Correct ? | 24 Yes | 2 No |
Answer / l meher
select * from emp minus select * from emp where rownum<=
(select count(*)-10 from emp);
Is This Answer Correct ? | 8 Yes | 3 No |
Answer / praveen biradar
select empno from (select empno from emp order by empno
desc) where rownum<=10 order by empno
Is This Answer Correct ? | 10 Yes | 6 No |
Answer / pallavi v
with temp as
(select * from emp order by rownum desc)
select * from temp where rownum < = 10
Is This Answer Correct ? | 0 Yes | 0 No |
select * from <TN>
minus
select * from <TN>
where
rownum <= (select count(*) - &n from <TN>)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nzabin
select PO_header_id from (select PO_header_id from PO_HEADERS_ALL order by PO_header_id
desc) where rownum <=10 order by PO_header_id;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sudhir
select rownum, p.*
from (select * from <table name> order by param_cd desc) p
where rownum <= 10 ;
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / akshaya
select * from last10
minus
select * from last10
where row >= (select COUNT(*)-10 from last10)
condition should be >= not <=
for all the above queries
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / swastik
SELECT ROWNUM, E1.*
FROM
(
SELECT * FROM Emp
ORDER BY ROWNUM DESC
)E1
WHERE ROWNUM <= 10
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / chandrakishan
select * from emp where rownum>=
(select count(*)-10 from emp);
Is This Answer Correct ? | 1 Yes | 3 No |
When should I use nosql database?
how are mysql timestamps seen to a user? : Sql dba
what is acid property in database? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How do I count records in sql?
How can we link a sql database to an existing android app?
How does pl sql work?
what is sql? : Sql dba
How is indexing done in search engines?
What are triggers in sql?
Mention what are the benefits of pl/sql packages?
what is blob? : Sql dba