Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373307 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 / mallika
SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is datawarehouse? : Sql dba
how is myisam table stored? : Sql dba
Does a primary key have to be a number?
what happens if null values are involved in expressions? : Sql dba
What are sql constraints?
Why self join is used in sql?
What is natural join in sql?
What is an implicit commit?
What is time based sql injection?
how many ways to get the current time? : Sql dba
What is trigger in pl sql with examples?
What is the purpose of the sql select top clause?
What is union, minus and interact commands?
What is full form of rtm?
what does the t-sql command ident_current does? : Transact sql
