Advertisements
Advertisements
प्रश्न
Explain the following SQL function using a suitable example.
DAYNAME()
उत्तर
DAYNAME(): It returns the weekday name for a given date.
Example: SELECT DAYNAME(‘2022-07-22’);
Output: Friday
APPEARS IN
संबंधित प्रश्न
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
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 substr("Computer", 4) = ______.
What will be returned by the given query? select power(3, 2) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.
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 ______.
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 output produced by the following SQL statement:
SELECT LENGTH("Informatics Practices");
Write the output produced by the following SQL statement:
SELECT LEFT("INDIA", 3), RIGHT("Computer Science", 4), MID("Informatics", 3, 4), SUBSTR("Practices", 3);
Which function is used to display the total number of records from a table in a database?
Differentiate between count() and count(*) functions in SQL with appropriate examples.
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?
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.
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:
Display the remainder of 100 divided by 9.
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()
