topic Re: explained me this select statement... in Application Development and Automation Discussions

explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:40:11 GMT

Hi all,

What do this select statement:

SELECT * UP TO 1 ROWS FROM LIPS WHERE ZZOBJNR = VA_L_OBJNR.

I have never seen "select * up to 1 rows".

Thanks all.

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:43:43 GMT

It will fetch only the first record from table even if more than one records match your selection criteria.

The action is similar to SELECT SINGLE *

Message was edited by: Sudhir Bhate

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:46:05 GMT

Fabrizio,

This will SELECT only one row from the database even if the where clause is satisfied by multiple rows.

I would rather suggest you to use SELECT single, which gives a better performance.

Regards,

Ravi

Note : Please reward the posts that help you.

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:46:26 GMT

what ever the record that satisifies the where condition it will fetch, and even if you have more records with that condition it will fetch the first record that satisfies the condition.

vijay

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:47:12 GMT

It's way to say to system to get out the first record is found.

You can also write this statament in this way:

SELECT * FROM LIPS WHERE ZZOBJNR = VA_L_OBJNR.

EXIT.

ENDSELECT.

SELECT SINGLE * FROM LIPS WHERE ZZOBJNR = VA_L_OBJNR.

But this last statament is not really correct, because ZZOBJNR is not the key of LIPS.

Max

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:47:41 GMT

OK, Thanks all....A lot of points for all...

Re: explained me this select statement...

Former Member — Thu, 22 Dec 2005 09:51:22 GMT

Hai Ballante,

Here is the explanation.

... UP TO n ROWS

Effect

This addition restricts the number of rows in the result set. A data object of the Type i is expected for n. A positive number in n indicates the maximum number of rows in the result set. If n contains the value 0, all selected rows are passed to the result set. If n contains a negative number, an exception that cannot be handled is raised.

If the addition ORDER BY is also specified, the rows of the hit list are sorted on the database server and only the number of sorted rows specified in n are passed to the result set. If the addition ORDER BY is not specified, n is filled with any number of rows in the result set that meet the WHERE condition.

with regards,

Manikandan R