topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Thu, 23 Jul 2009 05:07:02 GMT

Hi all,

I need to select data from a customized table.

for example the record in the customized table would look like this


machine     data1     data2     data3
A100001     SA1       SA2       SA3
A100002     SA4       SA5       SA6
B100001     SA7       SA8       SA9
C100001     SA1       SA2       SA3
B100001     SA4       SA5       SA6

How could the select statement to only select for only machine prefix is with "A". My expected data selected is


machine     data1     data2     data3
A100001     SA1       SA2       SA3
A100002     SA4       SA5       SA6

Thanks to all.

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:10:39 GMT

Hello

Yes. Try like this:


select * from ztable where machine LIKE 'A%'.

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:10:48 GMT

give

machine like 'A%'

or try

machine = 'A%'

in your where clause of select query.

Re: Select statement

sridhar_meesala — Thu, 23 Jul 2009 05:11:46 GMT

Hi,

Use the % operator with the SELECT statement.

SELECT * 
FROM table 
INTO itab 
WHERE machine = 'A%'.

Thanks,

Sri.

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:12:28 GMT

Hello frn.

use like statement in where clause with select statement ...

select * from <database table name > where f1 like '%A' .

and Please try F1 on LIKE staement .... you will get solution .

Thanks ..Priyank

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:13:50 GMT

hI,

You can try the following code.



SELECT * 
FROM IT_TAB 
INTO IT_TEMP
WHERE machine like 'A%'.

Regards,

Vik

Edited by: vikred on Jul 23, 2009 7:14 AM

Re: Select statement

sreeramkumar_madisetty — Thu, 23 Jul 2009 05:37:44 GMT

Use SORT TABLE BY MACHINE.

SELECT *

FROM table

INTO itab

WHERE machine = 'A%'.

Regards,

Sreeram

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:38:31 GMT

Hi,



select * from zdbtable into table it_tab where machine LIKE 'A%'.

Re: Select statement

Former Member — Thu, 23 Jul 2009 05:42:50 GMT

Hi,

SELECT machine

data1

data2

data3

FROM Ztable

INTO table ITAB

WHERE machine Like 'A%'.

Regards,

ShreeMohan