how to calcuate the second highest salary of he employee
Answer Posted / udhayakumar
select salary from (select salary from emp order by salary
desc) where rownum=2;
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is integrity in sql?
How to download oracle sql developer?
How do you take the union of two tables in sql?
What is indexing in sql and its types?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Are views faster than queries?
Does pl/sql support create command?
How many sql are there?
What are packages in pl sql and also explain its advantages?
Describe different types of general function used in sql?
Can you call pl/sql package functions from within a fast formula?
what are aggregate and scalar functions? : Sql dba
Is grant a ddl statement?
how to get a list of all tables in a database? : Sql dba
What are the different dml commands in sql?