SELECt

[Former Member]

Hi all

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

Vijay

[Former Member]

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.

[former_member253577]

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

[Former Member]

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

[Former Member]

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.

By

Pari

[Former Member]

select * from mara.

Retrives all the records from the mara table

select single * from mara.

Retrives only one record from the mara table.