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 particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?

Answer Posted / senthilkumar

SELECT TOP 1 Empid
FROM (SELECT DISTINCT TOP 6 Empid FROM Employees ORDER
BY Empid desc) a ORDER BY Empid asc

Is This Answer Correct ?    4 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1894


What is mscorsvw.exe - process - microsoft .net framework ngen?

939


What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1243


What is a transaction and why is it important?

1071


Why do we partition data?

1014


What is #temp and @table variable in SQL server?

1066


How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

169


Who is the owner of a schema in ms sql server?

1061


Explain where clause?

978


what is denormalization and when would you go for it? : Sql server database administration

1158


Explain features of analysis services?

980


What is an indexed view?

949


What is openrowset sql server?

1105


What is the most common trace flags used with sql server?

1028


is there a column to which a default can't be bound? : Sql server database administration

997