Advertisements
Advertisements
प्रश्न
Site any two differences between Single Row Functions and Aggregate Functions.
Advertisements
उत्तर
| Single Row Functions | Aggregate Functions |
| Single row functions operate on individual rows and return a single value per row. | Aggregate functions operate on groups of rows and return a single result for each group. |
| It can be used in SELECT, WHERE, and ORDER BY clause. | It can be used in the SELECT clause only. |
UPPER(name) → Converts each name to uppercase |
SUM(salary) → Returns total salary for all or a group of employees |
संबंधित प्रश्न
______ 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.
Which of the following is not an aggregate function?
Which command is used to delete a table? (in SQL)
What will be returned by the given query? Select round(23456.1234, -2) = ______.
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")) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
"COUNT" keyword belongs to which categories in Mysql?
What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.
Which of the following is not a date function?
The string function that returns the index of the first occurrence of substring is ______.
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 your name in capital letters.
Write the output produced by the following SQL statement:
SELECT ROUND(123.2345, 2),
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),
Differentiate between count() and count(*) functions in SQL with appropriate examples.
Predict the output of the code given below:
s="welcome2cs"
n = len(s)
m=""
for i in range(0, n):
if (s[i] >= 'a' and s[i] <= 'm'):
m = m +s[i].upper()
elif (s[i] >= 'n' and s[i] <= 'z'):
m = m +s[i-1]
elif (s[i].isupper()):
m = m + s[i].lower()
else:
m = m +'&'
print(m)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.
POWER()
