Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367634 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 / abhay
select max(sal) from emp where sal< (select max(sal) from
emp)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are variables in pl sql?
What are the operators used in select statements?
What is cte?
What is execute immediate?
Why do we use set serveroutput on?
How do you copy a table in sql?
What is the clause we need to add in function body to return variable?
What does cursor do in sql?
What are the different types of dbmss?
how to convert numeric values to character strings? : Sql dba
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
What is the usage of nvl function?
what is 'mysqldump'? : Sql dba
explain mysql aggregate functions. : Sql dba
What is consistency?
