sql to count the no. of entries

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.