Advertisements
Advertisements
प्रश्न
Explain the following SQL function using a suitable example.
MID()
Advertisements
उत्तर
MID(): It extracts the specified number of characters from the given string.
Example: SELECT MID(‘Welcome world,4,,4);
Output: Come
APPEARS IN
संबंधित प्रश्न
______ 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?
The char() function in MySql is an example of ______.
Which command is used to delete a table? (in SQL)
What will be returned by the given query? Select length(trim("ABC Public School")) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
Name a function of MySQL which is used to remove trailing and leading spaces from a string.
Name a function of MySQL used to give position of the first occurrence of a string2 in string1.
Which of the following is not a text function?
Which function will be used to remove only the trailing spaces from a string?
What is the general format of UPPER() return type?
Site any two differences between Single Row Functions and Aggregate Functions.
Write the name of the functions to perform the following operation:
To display the day like “Monday”, and “Tuesday”, from the date when India got independence.
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(123.2345, 2),
ROUND(342.9234, −1);
Which one of the following is not an aggregate function?
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:
Display 7 characters extracted from the 7th left character onwards from the string ‘INDIA SHINING’.
Write suitable SQL query for the following:
Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.
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.
TRIM()
Which function returns the sum of all elements of a list?
