SELECT statement

[Matt]

I have the following SQL statement, but I only want the
first 8 rows of this table, not all of them. can anyone
help??

Thanks in advance!!

SELECT medicine_code, med_name, med_name_sci,
med_name,_common
FROM medicine;

 

[Ed]

SELECT TOP 8 medicine_code, med_name, med_name_sci,
med_name,_common
FROM medicine;