what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 8572 Views
- I also Faced
- E-Mail Answers
Answer Posted / dipti saxena
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Difference between 2NF &3NF ?
How many joins in sql server?
What is ms sql server reporting services?
How will you know when statistics on a table are obsolete?
Does partitioning improve performance sql server?
What is CTE in SQL
What is precedence constraint?
Write the SQL query to drop, truncate and delete table.
How can we remove orphan records from a table?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
What is isnull() operator?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is candidate key with example?
What is #table in sql server?
Can I disable or restrict ssrs export formats (rendering formats)?
