Advertisements
Advertisements
Question
Which function returns the sum of all elements of a list?
Options
count()sum()total()add()
Advertisements
Solution
sum()Explanation:
The sum() function sums all elements of a list.
APPEARS IN
RELATED QUESTIONS
______ 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?
The char() function in MySql is an example of ______.
What will be returned by the given query? Select round(23456.1234, -2) = ______.
What will be returned by the given query? select day of year('2015-02-10') = ______.
What will be returned by the given query? select substr("Computer", 4) = ______.
What will be returned by the given query? select power(3, 2) = ______.
What will be returned by the given query? SELECT RIGHT("LEFT", 2) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
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 date function?
Which of the following is not a text function?
The string function that returns the index of the first occurrence of substring is ______.
What is the general format of UPPER() return type?
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 output produced by the following SQL statement:
SELECT ROUND(123.2345, 2),
ROUND(342.9234, −1);
Which function is used to display the total number of records from a table in a database?
Which type of values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM inventory;
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 outputs for SQL queries that are based on the given table PURCHASE:
| TABLE: PURCHASE | ||||
| CNO | CNAME | CITY | QUANTITY | DOP |
| C01 | GURPREET | NEW DELHI | 150 | 2022-06-11 |
| C02 | MALIKA | HYDERABAD | 10 | 2022-02-19 |
| C03 | NADAR | DALHOUSIE | 100 | 2021-12-04 |
| C04 | SAHIB | CHANDIGARH | 50 | 2021-10-10 |
| C05 | MEHAK | CHANDIGARH | 15 | 2021-10-20 |
- SELECT LENGTH(CNAME) FROM PURCHASE WHERE QUANTITY>100;
- SELECT CNAME FROM PURCHASE WHERE MONTH(DOP) = 3;
- SELECT MOD (QUANTITY, DAY(DOP)) FROM PURCHASE WHERE CITY = ‘CHANDIGARH’;
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:
Round off the value 23.78 to one decimal place.
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Explain the following SQL function using a suitable example.
DAYNAME()
