VishalMistry
23rd January 2010, 08:02
Hi all,

Is there any way to find out the number of records selected by the SQL SELECT statement ? e.g.

select tcibd001.* from tcibd001 where tcibd001.citg = 'ITMGRP'

How can I know (without using counter variable or COUNT function) the number of records selected by the above statement.

Vishal

Hitesh Shah
24th January 2010, 07:40
I dont think it's possible without count function in sql query or without a counter it's possible.