hai i am satish a student. i want the code to retrive only 5 rows of the table and place it in the dataset. please send the code if you can?
Loading
hai i am satish a student. i want the code to retrive only 5 rows of the table and place it in the dataset. please send the code if you can?
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Dinesh TawarPosted Apr 21, 2006, 12:50 AM
SELECT TOP 5 Column_Name(s )
FROM Table_Name
WHERE Condition
suresh mupparajuPosted Apr 18, 2006, 2:01 AM
select * from table name from tabale name
where count()<5;