Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 116133 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / baburav zore
select max(sal) from employee where sal<(select sal from employee);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the purpose of %type and %rowtype data types?
What is the difference between an inner and outer join?
what tools available for managing mysql server? : Sql dba
What will you get by the cursor attribute sql%notfound?
Write a query to display the current date in sql?
How sql query is executed?
What are the types of triggers in sql?
How to select unique records from a table?
Write a query to find the names of users that begin with "um" in sql?
Can we connect to postgresql using sql developer?
How to Declare Fixed Length String Value In PL SQL
How do I enable sql encryption?
what happens if null values are involved in expressions? : Sql dba
What is Histogram?
What is pls integer?
