how to find the second highest salary from emp table?
Answer Posted / hima
select sal from emp order by salary desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger in sql and its types?
what are set operators in sql? : Sql dba
What is update query?
discuss about myisam key cache. : Sql dba
Which data dictionary views have the information on the triggers that are available in the database?
what are different types of keys in sql?
What is information schema in sql?
What is sqlerrd?
What are sql functions? Describe the different types of sql functions?
How delete all data from all tables in sql?
What is forward declaration in pl sql?
Does sqlite need a server?
Is delete faster than truncate?
Is the primary key an index?
Why is the cursor important?