Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find five highest salaries from EMP table.
(there is a column SALARY)
- 24 Answers
- 52247 Views
- Cap Gemini, iNautix, I also Faced
- E-Mail Answers
Answer Posted / sarath
select ename,sal,SAlrank from(select ename,sal,dense_rank()
over(order by sal desc) Salrank from emp)
where salrank <=5
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How to use boolean type in select statement?
Is a table valued function object?
how is exception handling handled in mysql? : Sql dba
What are predefined functions in sql?
Is sqlexception checked or unchecked?
What is pls_integer in pl sql?
Why do we use view in sql?
What does dml mean?
What is structural independence and why is it important?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Who is the owner of mysql database?
Can we connect to postgresql using sql developer?
what is the use of set statement in tsql? : Transact sql
How do I create an index in word?
Can we insert data in view?
