Use
TOP
with
ORDER BY
clause in your query
If you want display TOP 3 records based on ID by descending order,
SELECT TOP 3 ID, cat_type FROM catagory ORDER BY ID DESC
or if you want display TOP 3 records based on ID by ascending order,
SELECT TOP 3 ID, cat_type FROM catagory ORDER BY ID ASC
If you want display TOP 3 records based on cat_type by descending order,
SELECT TOP 3 ID, cat_type FROM catagory ORDER BY cat_type DESC
or if you want display TOP 3 records based on cat_type by ascending order,
SELECT TOP 3 ID, cat_type FROM catagory ORDER BY cat_type ASC
Use the query based on your requirement.
EDIT
---------------------------------------------------------------
If you want to display only cat_type column then try like below
SELECT TOP 3 cat_type FROM catagory ORDER BY cat_type DESC
If still you are not clear then please show us what output do you want? Include the table structure with sample data. And show sample output which do you want. Let me know.