Advertisements
Advertisements
प्रश्न
Based on the table STUDENT given here, write suitable SQL queries for the following:
| Roll No | Name | Class | Gender | City | Marks |
| 1 | Abhishek | XI | M | Agra | 430 |
| 2 | Prateek | XII | M | Mumbai | 440 |
| 3 | Sneha | XI | F | Agra | 470 |
| 4 | Nancy | XII | F | Mumbai | 492 |
| 5 | Himanshu | XII | M | Delhi | 360 |
| 6 | Anchal | XI | F | Dubai | 256 |
| 7 | Mehar | X | F | Moscow | 324 |
| 8 | Nishant | X | M | Moscow | 429 |
- Display gender-wise highest marks.
- Display city-wise lowest marks.
- Display the total number of male and female students.
Advertisements
उत्तर
- select max(marks) from student group by gender;
- select min(marks) from student group by city;
- select gender, count(gender) from student group by gender;
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?
Which method is used to get the row-id of the last modified row?
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
Which of the following is not an aggregate function?
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 power(3, 2) = ______.
What will be returned by the given query? Select length(trim("ABC Public School")) = ______.
What will be returned by the given query? SELECT RIGHT("LEFT", 2) = ______.
Name a function of MySQL which is used to remove trailing and leading spaces from a string.
"COUNT" keyword belongs to which categories in Mysql?
Name a function of MySQL used to give position of the first occurrence of a string2 in string1.
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 function will be used to remove only the trailing spaces from a string?
The string function that returns the index of the first occurrence of substring is ______.
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 the specified number of characters from a particular position of the given string.
Write the output produced by the following SQL statement:
SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4),
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 the position of occurrence of the string ‘COME’ in the string ‘WELCOME WORLD’.
Write suitable SQL query for the following:
Display the remainder of 100 divided by 9.
Explain the following SQL function using a suitable example.
MID()
