Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368288 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 are different joins used in sql?
what is the bond code in materialized view?
What is compiled query?
State few characteristics of pl/sql?
what is sub-query? : Transact sql
What does select top 1 do in sql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How to know the last executed procedure?
Who developed sql?
How do you use join?
What are aggregate functions in sql?
what is the difference between cluster and non cluster index? : Sql dba
What are the triggers associated with image items?
How do I use google cloud in sql?
What is dml and ddl?
