topic Re: select stmt in Application Development and Automation Discussions

select stmt

Former Member — Thu, 17 Jan 2008 13:57:56 GMT

what is the difference between select single and select up to 1 row?

its urgent plz?

thank you.

Re: select stmt

Former Member — Thu, 17 Jan 2008 14:00:47 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.

Hope this helps

Vinodh Balakrishnan

Re: select stmt

Former Member — Thu, 17 Jan 2008 20:15:36 GMT

hi kaladhar,

Both select single and select up to 1 rows retrieves single record but the difference is in its usage.

Usually these select statements are used for screen validations.

if a particular field has check table then we use select single statement.

if a particular field doesn't have check table then we use select up to 1 rows.

reward if helpful

shashikanth naram.

Re: select stmt

Former Member — Thu, 17 Jan 2008 20:17:19 GMT

Select single statement, you need to give all primary key to select unique records. It is always selecting a single record based on your WHERE condition.

Select up to one row is mainly used for aggrecate function like sum up or count . It is also giving single record which is latest record in your table. if you wnat to retrival oldest one record, you need to use group by statement.