Select up to 1 row and select single difference ?

Go down

Select up to 1 row and select single difference ?

Post  naveenchepuri on Thu Feb 02, 2012 11:00 pm

Select single fetches first matching record. If more than one matching records are there then only the first matching record will be considered other records will not be taken into account. Where as select up to 1 rows will fetch all the matching records from the database.(Again it will assign only One Record to the internal table/Work area)

naveenchepuri

Posts : 23
Join date : 2012-01-31

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum