how to find the second highest salary from emp table?
- 211 Answers
- 322603 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 / jat16may
SELECT MAX(SALARY) FROM TABLENAME WHERE SALARY<(SELECT
MAX(SALARY) FROM TABLE NAME
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is trigger in sql and its types?
Can we create foreign key without primary key?
How can we optimize a sql query?
What is execute immediate?
What do you mean by dbms? What are its different types?
how to include character strings in sql statements? : Sql dba
Is a table valued function object?
How to use boolean type in select statement?
What is the difference between explicit and implicit cursors in oracle?
What is record data type?
What's the procedure?
What do you mean by query optimization?
how to show all tables with 'mysql'? : Sql dba
Can we insert in sql function?
Can pl sql procedure have a return statement?
