Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367893 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 / kiran
select max(sal) from emp where sal in(select sal from emp
where sal<>(select max(sal) from emp))
/
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I enable sql encryption?
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 is clustered index sql?
Explain normalization and what are the advantages of it?
What trigger means?
What is materialized view in sql?
Does sql between include endpoints?
What are the sql commands?
what are all types of user defined functions? : Sql dba
Explain foreign key in sql?
What is coalesce sql?
What are the differences between implicit and explicit cursors?
What is crud stand for?
Can a trigger call a stored procedure?
Explain the commit statement.
