Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368631 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / mohan rathour
select max(e1.salary) from Emp_table e1 where e1.salary not
in (select max(e2.salary) from Emp_table e2 )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to shutdown mysql server? : Sql dba
What are analytic functions in sql?
What do you think about pl/sql?
What does the sign mean in sql?
How many databases can sql express handle?
Write a sql query to get the third highest salary of an employee from employee_table?
Can we use pl sql in sql server?
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
What is cte?
What is the use of procedures?
Why do we use sql constraints?
Why function is used in sql?
What is sql indexing?
What are views in sql?
What is Histogram?
