topic Re: Select DISTINCT in Application Development and Automation Discussions

Select DISTINCT

Former Member — Tue, 29 Jul 2008 17:28:47 GMT

This is the select statement I am using -

SELECT DISTINCT FIELD1 AS FIELD1 FROM TABLE UP TO 1 ROWS

INTO TABLE I_TAB.

This is selecting the line but getting a initial line.

Its not retrieving any data.

Please tell me what has to be modified here?

Thanks,

Archana.

Former Member — Tue, 29 Jul 2008 17:32:25 GMT

what are you trying to retrieve?

Former Member — Tue, 29 Jul 2008 17:33:30 GMT

FIELD1 data Ravi.

Former Member — Tue, 29 Jul 2008 17:35:15 GMT

You want the first field in the table in the first record?

May be the first record has a blank value in it.

Regards,

Ravi

Former Member — Tue, 29 Jul 2008 17:35:35 GMT

REPORT  YEST_DB.

data: i_tab type vbap_t.

SELECT DISTINCT vbeln FROM  vbap up to 1 rows
INTO TABLE I_TAB.

break-point.

bpawanchand — Tue, 29 Jul 2008 17:36:53 GMT

Try query with out using UP TO 1 ROWS

Regards

Pavan

Former Member — Tue, 29 Jul 2008 17:39:49 GMT

Its still retrieving the bank lines.

Whats wrong?

Thanks,

Archana.

Former Member — Tue, 29 Jul 2008 18:32:33 GMT

Thanks for the help.