Advertisements
Advertisements
प्रश्न
Predict the output of the following query based on the table Sports given below:
Table: Sports
| Sid | SName | Fees | DateofPlay | CoachId |
| 1 | Karate | 1200 | 2024-08-24 | S1 |
| 2 | Football | 1800 | 2024-09-13 | S2 |
| 3 | Cricket | 1500 | 2024-06-14 | S3 |
| 4 | Lawn Tennis | 2500 | 2024-09-25 | S4 |
| 5 | Badminton | 1800 | 2024-10-20 | S5 |
SELECT UCASE(TRIM(SName)) FROM Sports WHERE Sid=5;
लघु उत्तरीय
उत्तर
Output: BADMINTON
Explanation:
When the Sid field in the Sports table equals 5, the supplied SQL query chooses the trimmed, uppercase SName column for that entry.
shaalaa.com
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
