select count( * ) into variable where condition You will get the number

How to get the no of records using select statement?

Question Posted / bhushan

Answer Posted / bhushan

select count( * ) into variable where condition

You will get the number of records...

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Define database layer?

1035

What happens Update command is used without where clause ?

1178

dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?

2948

What do you mean by transparent tables in sap abap? : abap data dictionary

1039

What is a logical database?

1202

What is a function group? : abap modularization

1081

what is diff between ECC 5.0 AND ECC 6.0

3301

What are the payroll related infotypes? : abap hr

1079

What is the use of a pretty printer?

1178

What is smart forms? : abap hr

1088

Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?

1095

What are the layers of data description in r/3? : abap data dictionary

1116

Explain what are the various types of selection screen event?

1081

Abstract class and interface, multiple inheritance, live example

1335

What are the sequences of event block?

1080