Informatics Practices
What will be the output of following code ?
mysql> SELECT CONCAT(LOWER('Class'), UPPER('xii'));
SQL Queries
1 Like
Answer
+--------------------------------------+
| CONCAT(LOWER('Class'), UPPER('xii')) |
+--------------------------------------+
| classXII |
+--------------------------------------+
Working
In the query, LOWER('Class') converts 'Class' to lowercase, resulting in 'class', and UPPER('xii') converts 'xii' to uppercase, resulting in 'XII'. The CONCAT() function then combines these two results, producing the final output 'classXII'.
Answered By
1 Like
Related Questions
What will be the output of following code ?
mysql> SELECT LCASE('INFORMATICS PRACTICES CLASS 11TH');What will be the output of following code ?
mysql> SELECT UCASE('Computer studies');If Str = "INFORMATICS PRACTICES …." and Str1 = "… FOR CLASS XI"
Write commands to print the output as 'informatics practices for class xi'
Write commands to display the system date.