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...

write query for fourth maximum salary from employee table

Answer Posted / yogendra barode

Select top 1 salary from (select top 4 salary from tbl_emp
order by salary desc) temp_tbl order by asc

Is This Answer Correct ?    5 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we return Data from 4(more than 1) tables in stored procedure?

1109


What are advantages of ssrs or why we should use ssrs?

145


Explain what is lock escalation and what is its purpose?

983


Explain tables in SQL Azure?

122


What is the report model project?

151


Explain data warehousing in sql server?

1092


What are the differences between sql server and mysql.

1143


What is the use of custom fields in report?

1042


what data regions are and what are the different data regions?

146


How to populate a table in sql server?

995


Does union all remove duplicates?

1123


Why variables called the most powerful component of ssis?

1126


What is user-defined inline table-valued function?

1004


You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1130


What is the osql utility?

1037