topic SELECt in Application Development and Automation Discussions

SELECt

Former Member — Mon, 24 Mar 2008 11:04:38 GMT

Hi all

What is the difference between "select * from mara" and "select single * from mara"?

Vijay

Re: SELECt

Former Member — Mon, 24 Mar 2008 11:06:26 GMT

Hi,

Select * from Mara

It will get all the data from the mara table based on the where condition.

select single * from mara

It will get single record from the mara based on the condition.

Thanks,

Sriram Ponna.

Re: SELECt

former_member253577 — Mon, 24 Mar 2008 11:08:28 GMT

Hi,

SINGLE *

The result of the selection should be a single entry. If it is not possible to identify a unique entry, the system uses the first line of the selection.

where as

Select *

will select all the entries .

Regards,

Sreekanth.G

Re: SELECt

Former Member — Mon, 24 Mar 2008 11:13:43 GMT

Hi Vijay

select single * from mara

You will get single record frm mara table .

Select * from Mara

You get all the data from the mara table.

Reward me points if it helpful.

Pari

Re: SELECt

Former Member — Mon, 24 Mar 2008 11:14:52 GMT

hi,

select * will select all the fields in the table mara based on the where condition,but it is not advised to use selet * frequently in the code because it creates the performance issues.

where as selec single * wil select a single field

Re: SELECt

Former Member — Mon, 24 Mar 2008 11:16:35 GMT

select * from mara.

Retrives all the records from the mara table

select single * from mara.

Retrives only one record from the mara table.