how to find the second highest salary from emp table?
Answer Posted / jude
first find first maximum
then easy to find second maximum
Is This Answer Correct ? | 98 Yes | 330 No |
Post New Answer View All Answers
How do I remove all records from a table?
What is the difference between local variables and global variables?
What is the difference between between and in condition operators?
how to present a past time in hours, minutes and seconds? : Sql dba
Can we use ddl commands in pl sql?
What is the difference between sql and isql*plus?
What is varchar data type in sql?
Mention what plvcmt and plvrb does in pl/sql?
What is partition by in sql?
What is the use of count (*) in sql?
Can sql function call stored procedure?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
Mention what are different methods to trace the pl/sql code?
How delete a row in sql?
Explain the types of joins in sql?