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

Write a sql query to get zero records from a table having n number of records?

1235


What are logical database components? : SQL Server Architecture

1095


Mention a few common trace flags used with sql server?

982


Where are sql server user names and passwords stored in sql server?

1155


What is a trigger and types of a trigger?

1029


Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1085


Explain concepts of analysis services?

1014


Why do we use stored procedures in sql server?

997


Why do you need a sql server?

1171


How to create a dml trigger using create trigger statements?

1084


Describe in brief sql server monitoring ways.

1102


What is mssql?

1031


Define model database?

1032


Give an example of SQL injection attack ?

1051


When would you use a before or after trigger?

957