Differences between single select &select up to 1 rows:-
Select single
Select up to 1 rows
1. It always retrieves only one record
at a time.
2. Here we must pass entire primary
key combination in the where
condition.
3. This is used to retrieve particular
record.
Syntax:-
1. It always retrieves only one
record.
2. Enough to pass a part of key
combination in the where condition.
It always picks the first record
among the matched records.
3. This is used for validation.
No comments:
Post a Comment