Primary key

[Former Member]

HIi Experts,

I Used select single * from a customised table and select 3 fields in that table i used.the problem is i used where condition.

in that where condition no primary key exist.

how can i do this problem.please send me clearly.

Thanks & regards

Srinivasareddy

[Former Member]

Hi,

if you execute the statement the first row of the rows that satisfies your condition will be placed in the result set.

As far you won't place a write lock (FOR UPDATE) PK is irrelevant here.

Please keep in mind that you can not specify an internal table after the INTO clause.

Flat structures are assumed here.

bye

yk

[narin_nandivada3]

Hi Srinivasareddy,

Use DISTINCT keyword in select statement... this avoids duplicates...

please go through this link...

[Select Distinct|http://www.sapbrainsonline.com/sapinfo/tutorial.php?artid=414]

For further help regarding select statement based on performance issue go through the below link

[Performance tuning when using select|http://www.sapmaterial.com/performanc_tuning.html]

Hope this would help you.

Good luck

Narin

[Former Member]

Hi,

IF you use SELECT SINGLE then you must use all the primary keys of the table to get valid data.

And in your case if you can not specify Primary keys then you can go for SELECT * FROM ZTABLE UP TO 1 ROWS statement.

Regards,

Sujit

[Former Member]

Hi Srini,

You can use SELECT DISTINCT ..

Check out this link:

http://www.sapbrainsonline.com/sapinfo/tutorial.php?artid=414

Regards,

Chandra Sekhar

[Former Member]

Thank you for yor response.

I solved my problem with your answer.