Restrict number of customer from database

Can you show your sql query to retrieve customers from database?

Yes, this my query to retrieve data :

Dim rs As New ADODB.Recordset
rs.Open "SELECT * from Customers", Conn,adOpenStatic ,adLockOptimistic 

However, i want to restrict all data to recordset is just only 50 customers.
How i can do this? Please help.

To limit your retrieved data from database you use TOP clause in your sql statement.
You can read in this site.

Select TOP 50 * from Customers

Wow...That code worked perfectly.
Thank you sir.