Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361087 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
what is the difference between primary key and unique key? : Sql dba
State few characteristics of pl/sql?
What is the use of primary key?
How is a PL/SQL code compiled?
How do I run a pl sql program?
what is row? : Sql dba
What does over partition by mean in sql?
How do I access sql anywhere database?
How do you modify a column in sql?
Can we call stored procedure in function?
What are local and global Indexes and where they are useful.
How do sql triggers work?
What are sql built in functions?
How can you view the errors encountered in a trigger?
i have some prob lem to tell me about my self in interview first round ...
