This Will give you last 10 records from a table SELECT EMPNAME,SALARY F

How do you retrieve the last N records from a table?

Question Posted / kiran penujuri

10 Answers
18477 Views
I also Faced
E-Mail Answers

Answer Posted / kiran penujuri

This Will give you last 10 records from a table

SELECT EMPNAME,SALARY
FROM
(SELECT EMPNAME,
SALARY,
RANK() OVER(ORDER BY SALARY) SAL_RANK
FROM EMP)
WHERE SAL_RANK < = 10

Is This Answer Correct ?

1 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is left join in sql?

1056

what are integrity rules?

1036

How do I partition in sql?

968

What type of join is sql join?

988

Can we create index on primary key?

977

Does asenumerable execute the query?

1051

What mean sql?

1019

Explain normalization and what are the advantages of it?

955

What is integrity in sql?

1053

Can we join two tables without common column?

1014

What are the types of variable use in pl sql?

1087

How do I view tables in sql developer?

957

What operators deal with null?

1111

Which data type is a composite type?

993

What are the different types of tables in sql?

1010