Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118285 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / babbu
it's easy with self join:
select max(sal) from emp e1,emp e2 where e1.sal < e2.sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is a stored procedure? : Sql dba
Why do we use joins in sql?
What are views in sql?
What is a file delimiter?
What is column?
Can we alter stored procedure?
Does a user_objects view have an entry for a trigger?
How to return an array from java to pl/sql?
What is the difference between sql and t sql?
What is sql engine in oracle?
how to create a table index in mysql? : Sql dba
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 does rownum mean in sql?
What is cold data?
Why do we use sql constraints?
