Answer Posted / siva prasad
SELECT B.* FROM
(SELECT A.*,DENSE_RANK() OVER(ORDER BY SAL DESC) V_SAL
FROM EMP A )B
WHERE V_SAL = 100
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
Which certification is best for sql?
what is the difference between primary key and unique key? : Sql dba
How delete a row in sql?
Explain what is table in a database?
What are inbuilt functions in sql?
What is a unique constraint?
How do you modify a trigger?
What is data manipulation language?
How is sql used in oracle?
What's the procedure?
How can you know that statistics should be updated?
How do I save a sql query?
What is pl sql in oracle?
Can a varchar be a primary key?
Why we use cross join?
