Let's say i have customer table where i have 1000's of records. If i want to retrive only first 10 rows from the customer table. HOW do i do that?

can any one write the code for me?

You need to define "TOP 10", eg, the first 10 records entered, the first 10 alphabetically by name etc.

SELECT TOP 10 UserFirstName, UserSurname FROM myTable ORDER BY UserSurname

the "top 10" is the key - it selects the TOP 10 records that match the criteria.

Cheers
Ken

Microsoft MVP - Windows Server (IIS)
www.adOpenStatic.com

Note: This requires using a database system that supports the TOP keyword.