Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367822 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 / surya
Select max(sal) from employee where sal not in(select max
(sal) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql partition?
What is the best partition size for windows 10?
What is trigger point?
What are different types of tables in sql?
How to raise user-defined exception with custom sqlerrm ?
What is normalization? How many normalization forms are there?
What are the popular database management systems in the it industry?
what is the difference between delete and truncate statement in sql? : Sql dba
Why should I use postgresql?
Why use stored procedures?
What is trigger in pl sql with examples?
Does access use sql?
What makes a good primary key?
What is sqlerrm?
What jobs use sql?
