Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find the second highest salary from emp table?

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


Please Help Members By Posting Answers For Below Questions

how to enter characters as hex numbers? : Sql dba

1104


Describe different types of general function used in sql?

1093


What is write ahead logging in sql server?

1101


Can a primary key be a foreign key?

1081


Why do we use subquery?

1080


How many types of triggers are there in pl sql?

1120


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1303


Are stored procedures faster than queries?

991


Which software is used for pl sql programming?

1034


write an sql query to find names of employee start with 'a'? : Sql dba

1089


How do I remove duplicates in two columns?

1150


What is difference between left and right outer join?

1038


What are the 3 modes of parameter?

1209


What is the difference between left join and right join?

990


Does pl sql work in mysql?

1036