Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 38658 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / somanath
select sal from emp a where 3=(select
count(distinct(sal)) from emp b
where a.sal<=b.sal)
| Is This Answer Correct ? | 34 Yes | 7 No |
Post New Answer View All Answers
What is data modelling in sql?
What is a crud api?
What is lookup table in sql?
Is foreign key mandatory?
Explain the savepoint statement.
What is transaction control language (tcl)?
What is range partitioning?
Is sql open source?
What is graph sql?
Why self join is used in sql?
what happens if null values are involved in expressions? : Sql dba
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How to use transactions efficiently : transact sql
What is sp_helptext?
How do I add a primary key to a table?
