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

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128


How to name query output columns in ms sql server?

1017


On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

1251


How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1255


What is sql view?

1121


What is database replication? What are the different types of replication you can set up in sql server?

1019


Explain steps of normalization?

1068


What is table-valued sub query?

1028


What is trace flag in sql server?

1085


Define clusters?

1143


What command would you use to create an index?

1114


What is logshipping and its purpose?

1073


What is difference between line feed ( ) and carriage return ( )?

951


How to create a new table in a given schema?

1256


Why is replication required on the sql server?

1108