Answer Posted / sanjay kumar
Select * from
(select distinct salary, dense_rank()over (Order by salary desc) rk from emp)
Where rk=100;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Which join is like inner join?
How do you get column names only for a table (sql server)?
Why indexing is needed?
Which constraints we can use while creating database in sql?
How is debugging done?
Why should I use postgresql?
Define concurrency control. : Transact sql
What is a database event trigger?
What is column?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Do we need commit after truncate?
What is the use of triggers?
What is cold data?
What is inner join in sql?
what is the difference between undefined value and null value? : Sql dba