Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368962 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 / vijay shegokar
select * from employee where salary=(select max(salary) from
employee where salary not in (select max(salary) from
employee));
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Are stored procedures faster than queries?
how to get a list of columns in an existing table? : Sql dba
How to write a query to show the details of a student from students table whose
What are system versioned tables?
explain advantages of myisam over innodb? : Sql dba
What is scalar function in sql?
List out the acid properties and explain?
What is mdf ldf and ndf?
What is rownum and rowid?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How do I access sql anywhere database?
How do sql triggers work?
how to show all tables with 'mysql'? : Sql dba
What is the limitation on the block size of pl/sql?
What is meant by user defined function?
