Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367879 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 / parvezkhan pathan
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
How to run sql functions in pl/sql?
How do I view a view in sql?
What are two statement types in sql?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
How do I start sql profiler?
What is the difference between join and natural join?
What are the most important characteristics of pl/sql?
What are pl/sql cursor exceptions?
Where do we use pl sql?
What is autocommit sql?
How is indexing done in search engines?
What is the difference between delete and truncate statement in sql?
Is truncate ddl or dml?
How to load data with sql*loader?
What is a temporal data type?
