1)what is the disadvantage of using 'select single'?
2)when we have to go for 'select single'&select.... up to 1 rows?
3)why we have to use only primary key fields on 'select single' statement?