Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368955 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 / arvind
select max(salary) from table_name where sal<(select
max(salary) from table_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Is keyword pl sql?
What is the usage of sql functions?
How do I partition a table in sql?
Which is faster truncate or drop?
what is innodb? : Sql dba
What is dynamic query?
What is the difference among union, minus and intersect?
How do I run a pl sql procedure in sql developer?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What are the ddl commands?
What is difference between nchar and nvarchar?
How to download oracle sql developer?
Which is faster joins or subqueries?
What is a schema sql?
Enlist the advantages of sql.
