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 / sneha s

fetch the 5th record from a table of 10 records:
select * from emp limit 4,1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1016


What is the difference between DataRow.Delete() and DataRow.Remove()?

1213


What is awe?

991


What is raid and what are different types of raid levels?

1131


Is sql server is free?

952


What do you understand by recursive stored procedures?

972


What are cascading parameters in ssrs reports?

229


What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

938


How check triggers in sql server?

966


Can I save my report as html, excel or word? : sql server management studio

932


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2129


What are distinctive joins find as a part of sql?

939


Explain what is dbcc?

995


What is the difference between substr and charindex in the sql server?

1074


What do you understand by replication in sql server?

1046