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
18346 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 memory optimized?

1065

what is self join and what is the requirement of self join? : Sql dba

1121

How do you delete data from a table?

1009

In pl/sql, what is bulk binding, and when/how would it help performance?

981

What is anonymous block in sql?

1107

How do I run sql?

1148

What is the best free sql database?

1040

what is the difference between where clause and having clause? : Sql dba

982

What are the two characteristics of a primary key?

958

What is sql engine in oracle?

971

i have some prob lem to tell me about my self in interview first round ...

2150

What is t sql in sql server?

1055

How can a function retun more than one value in oracle with proper example?

1061

What is the usage of sql functions?

1128

What is recursive stored procedure?

1082