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 salary?

Answer Posted / rajkumar v

Select min(salary)FROM emp WHERE (salary IN (SELECT TOP 2
salary FROM emp ORDER BY salary DESC))

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between cross join and full outer join?

925


What authentication modes does sql server support?

1023


What is scheduled job and how to create it?

925


What is join query?

840


What is index in an assignment?

894


Can we use trigger new in before insert?

868


how you can move data or databases between servers and databases in sql server? : Sql server administration

917


Which language rdl files made of?

124


How many types of built in functions are there in sql server 2012?

876


What is sql server locking?

937


Explain what is use of dbcc commands?

993


What are the authentication modes in sql server? How can it be changed?

1056


what are constraints? Explain different types of constraints? : Sql server database administration

921


What do you mean by an execution plan? How would you view it?

871


How do you trace the traffic hitting a sql server?

1072