Interested to Buy Any Domain ? << Click Here >> for more details...
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
How do I add a database to sql?
how do you login to mysql using unix shell? : Sql dba
What is the starting oracle error number?
How does cross join work in sql?
What are the three forms of normalization?
What are sql*plus environment variables?
Can you rollback after commit?
What is the difference between rename and alias?
Explain the commit statement.
how do you know the version of your mysql server? : Sql dba
When to use inner join and left join?
What is difference between sql and oracle?
Is record in pl sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Why do we use procedures in pl sql?
