InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is The Difference Between Select Single And Select Up To One Row? |
|
Answer» SELECT SINGLE can be USED if you know the FULL key to select a record. If you do not have the full Key to select and you are interested in one single row, you COULD use SELECT UPTO 1 ROWS. If you use a SELECT SINGLE WITHOUT a full key, you would GET a warning message in Extended Program checks. If you have the full Key use SELECT SINGLE If you do not have the full Key to select and you are interested in one single row, you could use SELECT UPTO 1 ROWS.. SELECT SINGLE can be used if you know the full key to select a record. If you do not have the full Key to select and you are interested in one single row, you could use SELECT UPTO 1 ROWS. If you use a SELECT SINGLE without a full key, you would get a warning message in Extended Program checks. If you have the full Key use SELECT SINGLE If you do not have the full Key to select and you are interested in one single row, you could use SELECT UPTO 1 ROWS.. |
|