Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368948 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 / kishor
select max(salary ) from employee
where
sal<(select max(salary)from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is sql an operating system?
can a stored procedure call itself or recursive stored procedure? : Sql dba
What is before trigger?
Why do we use set serveroutput on?
What is indexes?
What is the difference between between and in condition operators?
How do we use distinct statement? What is its use?
What is a trigger word?
Which one is faster ienumerable or iqueryable?
Why we use join in sql?
Does sql require a server?
Is drop table faster than truncate?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How many clustered indexes can you have?
What is oracle sql called?
