Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to get 2nd maximum salary in an employee table ?
- 69 Answers
- 118301 Views
- Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP, I also Faced
- E-Mail Answers
Answer Posted / sandip
SELECT MAX(SAL) FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
The correct one is.......
SELECT MAX(SAL) as SAL FROM EMPLOYEE WHERE SAL<(SELECT MAX(SAL)
FROM EMPLOYEE);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger and stored procedure in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
What will you get by the cursor attribute sql%found?
What company owns postgresql?
What is a string data type in sql?
Explain constraints in sql?
What is the difference between a query and a report?
What is the use of sqldataadapter?
Show code of a cursor for loop.
What is difference between my sql and sql?
How many triggers can be applied on a table?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Why query optimization is needed?
What is where clause in sql?
