sql to count the no. of entries

[Former Member]

Hi all,

I know that we can count the no. of entries with

SY-DBCNT,

but besides this, can I directly use sql statement, e.g. select count...

to count the no. of entries?

Thanks.

[Lakshmant1 · Accepted solution]

Hi Macy,

Yes you can use the SQL statement and it is the advised methid to find the count of the records.

Thanks

Lakshman

[MariaJoãoRocha]

Hi,

You can:

Select count(*)

from table

where ....

Check the sy-dbcnt.

Regards,

Maria João Rocha

[Former Member]

Hi Macy,

We can use like this.

SELECT count(*) into l_var1

from <db table>

where <cond>.

I think the above statement solves your problem.

Regards,

Ganesh N

[ralf_geiger]

Hi Macy,

I would also suggest using SY-DBCNT or DESCRIBE <itab> ... if possible. When using COUNT(*) in a database select it always bypasses the buffer and we should avoid that if possile

Regards,

Ralf

[Former Member]

Hi,

You can use DESCRIBE table itab into va_count.

this will give you the number of rows.

Lokesh

Pls. reward appropriate points

[abdul_hakim]

Hi

It is advisable to use sy-dbcnt to count,your COUNT(*) will pass another request from appl.server to database.server..Performance!!

My choice is sy-dbcnt..

Abdul

[former_member188685]

Hi,

You can use select count to count the no of entries.

thanks

vijay