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;
लघु उत्तर
Advertisements
उत्तर
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
या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
