Advertisements
Advertisements
Question
Explain the following SQL function using a suitable example.
MID()
Advertisements
Solution
MID(): It extracts the specified number of characters from the given string.
Example: SELECT MID(‘Welcome world,4,,4);
Output: Come
APPEARS IN
RELATED QUESTIONS
______ is used to get a specified day of the month for a given date.
______ keyword is used to find out the number of values in a column?
Which method is used to get the row-id of the last modified row?
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
What will be returned by the given query? Select round(23456.1234, -2) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
Which of the following is not a text function?
What is the general format of UPPER() return type?
Write the name of the functions to perform the following operation:
To display the specified number of characters from a particular position of the given string.
Write the name of the functions to perform the following operation:
To display the name of the month in which you were born.
Write the name of the functions to perform the following operation:
To display your name in capital letters.
Write the output produced by the following SQL statement:
SELECT ROUND(342.9234, -1);
Write the output produced by the following SQL statement:
SELECT YEAR(“1979/11/26”),
MONTH(“1979/11/26”), DAY(“1979/11/26”), MONTHNAME(“1979/11/26”);
Write the output produced by the following SQL statement:
SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4), MID("Informatics", 3, 4), SUBSTR("Practices", 3);
Which function is used to display the total number of records from a table in a database?
If column “Fees” contains the data set (5000,8000,7500,5000,8000), what will be the output after the execution of the given query?
SELECT SUM (DISTINCT Fees) FROM student;
Which one of the following functions are used to find the largest value from the given data in MySQL?
In SQL, which function is used to display the current date and time?
Write suitable SQL query for the following:
Round off the value 23.78 to one decimal place.
Explain the following SQL function using a suitable example.
UCASE()
Explain the following SQL function using a suitable example.
DAYNAME()
Shreya, a database administrator has designed a database for a clothing shop. Help her by writing answers to the following questions based on the given table:
| TABLE: CLOTH | |||||
| CCODE | CNAME | SIZE | COLOR | PRICE | DOP |
| C001 | JEANS | XL | BLUE | 990 | 2022-01-21 |
| C002 | T-SHIRT | M | RED | 599 | 2021-12-12 |
| C003 | TROUSER | M | GREY | 399 | 2021-11-10 |
| C004 | SAREE | FREE | GREEN | 1299 | 2019-11-12 |
| C005 | KURTI | L | WHITE | 399 | 2021-12-07 |
- Write a query to display cloth names in lowercase.
- Write a query to display the lowest price of the clothes.
- Write a query to count the total number of clothes purchased in medium size.
OR
Write a query to count the year-wise total number of clothes purchased.
Which function returns the sum of all elements of a list?
