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
what are local and global variables and their differences? : Sql dba
What are the different types of database management systems?
Is trigger a stored procedure?
How long does it take to learn pl sql?
What are the two different parts of the pl/sql packages?
what is offset-fetch filter in tsql? : Transact sql
What is sql character function?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
how to include character strings in sql statements? : Sql dba
Enlist the data types that can be used in pl/sql?
What is a database? Explain
Show the two pl/sql cursor exceptions.
Is sql a scripting language?
what are myisam tables? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
