Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373313 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 / ashwini
select max(salary) from employee where salary < (select max(salary) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can I change database name in sql?
what is the difference between truncate and delete statement? : Transact sql
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Which query operators in sql is used for pattern matching?
Can triggers stop a dml statement from executing on a table?
What is right join sql?
What is full join in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are different types of keys?
What are the types of operators available in sql?
What is set serveroutput on in pl sql?
How do I make my sql query run faster?
What is the difference between null value, zero, and blank space?
What is an intersect?
What is an oracle stored procedure?
