topic Re: select in Application Development and Automation Discussions

select

Former Member — Tue, 10 Jun 2008 13:54:16 GMT

Hi all,

i want to the exact difference between select and select single.can any one give me clarification on this.

thanks

hyma

Re: select

Former Member — Tue, 10 Jun 2008 14:03:39 GMT

SELECT SINGLE is to extract only one record: so if u want to be sure to extract the right record u should use only the key fields in WHERE conditions, else the SELECT SINGLE returns the first one found.

SELECT SINGLE * FROM <table> WHERE <condition>.

SELECT is to extract all records satisfating a certain condition, so SELECT is cycle and it needs to be closed by ENDSELECT.

SELECT * FROM <table> WHERE <condition>.

ENDSELECT.

It can obtain something as SELECT SINGLE using SELECT/ENDSELCT statament with the option UP TO 1 ROWS or EXIT:

SELECT * UP TO 1 ROWS FROM <table> WHERE <condition>.

ENDSELECT.

SELECT * FROM <table> WHERE <condition>.

EXIT.

ENDSELECT.

Max

Re: select

Former Member — Tue, 10 Jun 2008 14:14:31 GMT

Select : fetches all the records from the database table satsifying the where condition

Select single : fetches only one record from the database table eventhough the specified where condition matches many records

Hope this helps U

Re: select

Former Member — Wed, 11 Jun 2008 05:14:23 GMT

<completely_removed_by_moderator>

Rgds,

Rajyalakshmi.

Edited by: Julius Bussche on Aug 20, 2008 10:07 PM

Re: select

Former Member — Wed, 11 Jun 2008 05:53:34 GMT

The 'SELECT SINGLE' statement selects the first row in the database that it finds that fulfils the 'WHERE' clause If this results in multiple records then only the first one will be returned and therefore may not be unique.

The 'SELECT .... UP TO 1 ROWS' statement is subtly different. The database selects all of the relevant records that are defined by the WHERE clause or lack of, applies any aggregate, ordering or grouping functions to them and then returns the first record of the resultant result set.

Re: select

Former Member — Wed, 11 Jun 2008 07:06:10 GMT

Hi hyma,

pls se these threads. u can get bettter idea.

thanks

shankar