Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367455 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 / ankit khanijau
Select salary from emp
where MAX(Select salary from emp where salary != MAX(salary))
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how to see the create table statement of an existing table? : Sql dba
what is cross join? : Sql dba
explain normalization concept? : Sql dba
What are the different types of dbms?
What is normalization? How many normalization forms are there?
What is the advantage of index in sql?
Why stored procedure is faster than query?
How do you pronounce sql?
What does seeding a database mean?
How do you modify a trigger?
How do I add a database to sql?
What is indexing in sql and its types?
What is the difference between instead of trigger and after trigger?
What is a subquery in sql?
What is crud diagram?
