Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368633 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 / harish
select * from emp where 2=(select count(distinct sal) from emp s where s.sal>e.sal
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
- 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?
What does count (*) do in sql?
what is sql? : Sql dba
How delete all data from table in sql?
Does sql between include endpoints?
Which are the different case manipulation functions in sql?
What is the use of function in sql?
What is trigger types in sql?
How do I remove all records from a table?
What are the three forms of normalization?
Why do we use procedures?
Does sql*plus have a pl/sql engine?
What is the left table in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is native sql query?
