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

Difference between drill down and drill through report.

940


You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

970


How to use clusters?

924


What objects does the fn_my_permissions function reports on? : sql server security

1023


What are the elements of dbms?

951


What is dbcc updateusage?

1179


How many databases instances are there in sql server 2000?

1079


What is a domain constraint give an example?

1031


Can you please differentiate between a primary key and a unique key?

997


How to count duplicated values in a column in ms sql server?

1060


How to identify current user in ssrs report?

401


How to convert binary strings into integers in ms sql server?

1008


What is enhanced database mirroring in sql server 2008?

954


What is the use of custom fields in report?

984


How would you go about developing a ssrs report?

166