how to calcuate the second highest salary of he employee
Answer Posted / sunilpanghal
select rownum as rowid,salary from (salary from employees
oderby salary )where rownum <2
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the difference between inner join and natural join?
How to check if a column is nullable before setting to nullable?
What is server name sql?
How do you run a query?
How delete all data from all tables in sql?
What are actual parameters and formal parameters?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
what is transaction? : Sql dba
How to return multiple rows from the stored procedure?
What is the difference between nested table and varray?
What are different clauses used in sql?
what are numeric data types? : Sql dba
Why having clause is used in sql?
Why do we use view in sql?
What is the difference between function, procedure and package in pl/sql?