how to find the second highest salary from emp table?
Answer Posted / sheela
Select top 2 sal from (select sal from emp order by sal
desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is nvarchar in sql?
How to write html code in pl sql?
what is cursor. write example of it. What are the attributes of cursor.
Does sql require a server?
How can I make sql query run faster?
explain the delete statements in sql
how to check myisam tables for errors? : Sql dba
How to create your own reports in sql developer?
What is the purpose of normalization?
What are instead of triggers?
Do stored procedures prevent sql injection?
explain normalization concept? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
How can get second highest salary in sql?