Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368940 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 / mallika
SELECT salary FROM employee a
WHERE &n IN (SELECT COUNT(*) FROM employee b
WHERE a.salary <= b.salary)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What are types of indexes in sql?
What is difference between db2 and sql?
what is the difference between nested subquery and correlated subquery?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What are properties of the transaction?
Which type of cursor is used to execute the dml statement?
What are the different parts of a package?
Is a foreign key always unique?
How can I delete duplicate rows?
Write a sql query to find the names of employees that begin with ‘a’?
How do I install microsoft sql?
Can we call procedure in select statement?
how to get a list of indexes of an existing table? : Sql dba
Are left and right joins the same?
What is column?
