count number of rows in query
-
Hi all, What is the easiest way to count the number of rows in a SQL query? I have been looking for a methode but wasn't able to find one?! regards Stijn
-
Hi all, What is the easiest way to count the number of rows in a SQL query? I have been looking for a methode but wasn't able to find one?! regards Stijn
If you are firing SQL queary ,then there is no way to get the number of rows get selected.Untile you collect the records in Dataset. Sreejith Nair [ My Articles ]
-
Hi all, What is the easiest way to count the number of rows in a SQL query? I have been looking for a methode but wasn't able to find one?! regards Stijn
do u want the number of records the query fetches. If yes, prepare the sql string like the one below
Selcet Count(1) as RecordNum, col2, col3.... from table_name;
here "Count(1) as RecordNum" will give you the number of rows. Regards, Jay