Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367624 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 / rajkumar
SELECT * FROM TABLE WHERE columnName =
(SELECT MAX(column_name) FROM TABLE WHERE
column_name<(SELECT max(column_name) FROM TABLE))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why we use sql profiler?
Why do we use cursors?
Which is faster count (*) or count 1?
Can we have two clustered index on a table?
What are the possible values for the boolean data field?
How do you create a unique index?
how to convert character strings to numeric values? : Sql dba
What are different joins used in sql?
What is oracle and pl sql?
What are the three forms of normalization?
Is progress software supports to ( pl/sql )?
Why do we go for stored procedures?
Why is sql better than hql?
What is data type in sql?
Enlist some predefined exceptions?
