how to find the second highest salary from emp table?
Answer Posted / bharat puri
select top 2 (salary) from emp
order by salary desc
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how can you create an empty table from an existing table? : Sql dba
How to change the order of columns in Oracle SQL Plus ?
Differentiate between pl/sql and sql?
explain advantages of myisam over innodb? : Sql dba
Explain the uses of control file.
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is application trigger?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is a file delimiter?
What is oracle and pl sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is t sql in sql server?
how to get @@error and @@rowcount at the same time? : Sql dba
what are the advantages and disadvantages of cascading style sheets? : Sql dba
explain mysql aggregate functions. : Sql dba