Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361221 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 / shiva kumar
select max(salary) from table01
where salary <(select max salary from table01)
in mainframe env
| Is This Answer Correct ? | 27 Yes | 13 No |
Post New Answer View All Answers
what is cursor. write example of it. What are the attributes of cursor.
What is difference between db2 and sql?
What are the three forms of normalization?
Enlist the characteristics of pl/sql?
What is the advantage of index in sql?
How do I remove duplicates in two columns?
What is cross join sql?
What is the difference between the sql*loader and import utilities? : aql loader
what are the differences between require and include, include_once and require_once? : Sql dba
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
what is unique key constraint? : Sql dba
How to read xml file in oracle pl sql?
What is row_number () in sql?
how to do backup entire database? : Transact sql
What is sql profiling in oracle?
