topic Re: Primary key in Application Development and Automation Discussions

Primary key

Former Member — Tue, 19 Aug 2008 05:38:35 GMT

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 — Tue, 19 Aug 2008 06:30:07 GMT

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

narin_nandivada3 — Tue, 19 Aug 2008 06:33:39 GMT

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 — Tue, 19 Aug 2008 06:34:52 GMT

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 — Tue, 19 Aug 2008 06:41:31 GMT

Hi Srini,

You can use SELECT DISTINCT ..

Check out this link:

Regards,

Chandra Sekhar

Former Member — Tue, 19 Aug 2008 12:35:37 GMT

Thank you for yor response.

I solved my problem with your answer.