Question { Genpact, 8677 }
What is the difference between select single and select upto
1 rows?
Answer
Both will fetch 1 record from table. Select single is used when all the key of the table are to be matched in where condition. Select upto is used when any of the key is missing in the where condition.