Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368413 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 / khushbu
select max(salary) from emp where salary not in (select
max(salary) from emp)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by dbms? What are its different types?
what is error ora-03113: end-of-file on communication channel?
Why do we need cursors in pl sql?
Can we use pl sql in sql server?
State some properties of relational databases?
How do I delete a trigger?
What is auto increment in sql?
What if we write return in procedure?
How do you define a foreign key?
Why we use join in sql?
Can we insert data into materialized view?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Can we use pl sql in mysql?
Explain select statements in sql?
Why do we use view in sql?
