Advertisements
Advertisements
प्रश्न
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Advertisements
उत्तर
select mod(100,9);
APPEARS IN
संबंधित प्रश्न
______ keyword is used to find out the number of values in a column?
Which of the following belongs to an "aggregate function"?
The MAX () function finds the
The char() function in MySql is an example of ______.
Identify Single Row function of MySQL among the following.
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 length(trim("ABC Public School")) = ______.
Name a function of MySQL which is used to remove trailing and leading spaces from a string.
What will be returned by the given query? SELECT MID('BoardExamination', 2, 4) = ______.
What will be returned by the given query? SELECT DAYOFYEAR('2015-01-10') = ______.
Which of the following is not a date function?
What is the general format of UPPER() return type?
Which statement is used to count the number of rows in table?
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 your name in capital letters.
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;
Which one of the following functions are used to find the largest value from the given data in MySQL?
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:
Display the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.
Write suitable SQL query for the following:
Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.
Explain the following SQL function using a suitable example.
UCASE()
Explain the following SQL function using a suitable example.
POWER()
Which function returns the sum of all elements of a list?
