Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368636 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / shanmugasundaram
select min(salary) from tblempsal where salary in(select
distinct
top 2 salary from
tblempsal order by salary desc)
| Is This Answer Correct ? | 20 Yes | 13 No |
Post New Answer View All Answers
what is recursive stored procedure? : Sql dba
how to install mysql? : Sql dba
What are the different type of joins in sql?
How do I kill a query in postgresql?
What is the difference between distinct and unique in sql?
Explain the savepoint statement.
What are the different types of functions in sql?
How do I count rows in sql?
Can 2 queries be executed simultaneously in a distributed database system?
How to move files from one directory to another in pl sql?
What is primary key sql?
How do sql triggers work?
what is union, minus and interact commands? : Sql dba
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
What is before trigger?
