topic meaning in Application Development and Automation Discussions

meaning

Former Member — Wed, 12 Mar 2008 07:21:15 GMT

HI,

Please explain me what exactly the follwing select statement doing.....and also can you please tell me the solution to avoid the select *

SELECT COUNT( * )

FROM nast

INTO l_count

WHERE kappl = nast-kappl

AND objky = nast-objky

AND kschl = nast-kschl

AND spras = nast-spras

AND parnr = nast-parnr

AND parvw = nast-parvw.

Thanks in advance.

Re: meaning

Former Member — Wed, 12 Mar 2008 07:24:07 GMT

COUNT(*) supplies the total number of values (rows in a result table or group)

It counts the number of entries in table NAST based on the condition

Regards

Shiva

Re: meaning

Former Member — Wed, 12 Mar 2008 07:28:23 GMT

Hi,

count( * ) returns number of records

in table

COUNT is a set function.

· COUNT(*) supplies the total number of values (rows in a result table or group).

· COUNT(DISTINCT )supplies the number of values that differ from the NULL value (number of values in the argument of the ALL function)

The result has the data type FIXED(10).

Example table: customer

How many customers are there?

SELECT COUNT (*) number FROM customer

Regards

Re: meaning

Former Member — Wed, 12 Mar 2008 07:28:34 GMT

Hi,

it will give u the total number o f records in the table NAST which are satisfying the conditions mentioned in the where clause.

rgds,

bharat.

Re: meaning

Former Member — Fri, 14 Mar 2008 14:35:45 GMT

Hi Ginger,

From the select statement you get the total number of records that are present in NAST that satisfy the WHERE condition. Instead of COUNT(*), you can use the system variable sy-dbcnt to determine the number of records that will be read using the select statement.