Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368302 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 / raju tt
select max(salary) from employees where salary not in
(select max(salary) from employees)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is clustered and nonclustered index in sql?
What is the difference between local variables and global variables?
Explain scalar functions in sql?
what is union? : Sql dba
what is timestamp in mysql? : Sql dba
Does sql between include endpoints?
what is the difference between clustered and non clustered index in sql? : Sql dba
What is a temporal data type?
How do I tune a sql query?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What is the unique index?
what is heap table? : Sql dba
What is the difference between left join and right join?
Can there be 2 primary keys in a table?
How do you write a complex sql query?
