Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361133 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 / rajiv singh
select max(department_id) from departments where
department_id <(select max(department_id) from departments);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql table? Why it is used?
How to return multiple rows from the stored procedure?
What does plv msg allows you to do?
What is sql dialect?
What is the difference between alter trigger and drop trigger statements?
How does index help in query performance?
what is the bond code in materialized view?
what are numeric data types? : Sql dba
What are all the ddl commands?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
how do you know the version of your mysql server? : Sql dba
What is the use of partition by in sql?
What does (+) mean in sql joins?
What are the sql aggregate functions?
How do you go back in sql?
