Advertisements
Advertisements
प्रश्न
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.
Advertisements
उत्तर
MID( ) or SUBSTRING( )
संबंधित प्रश्न
______ 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 of the following belongs to an "aggregate function"?
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Which command is used to delete a table? (in SQL)
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 mid("Computer", 2, 4) = ______.
What will be returned by the given query? select day of year('2015-02-10') = ______.
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) = ______.
What will be returned by the given query? SELECT MID('LeaminglsFun', 2, 4) = ______.
Which of the following is not a date function?
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 ______.
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 LEFT("INDIA", 3), RIGHT("Computer Science", 4),
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 is not an aggregate function?
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:
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.
POWER()
Shreya, a database administrator has designed a database for a clothing shop. Help her by writing answers to the following questions based on the given table:
| TABLE: CLOTH | |||||
| CCODE | CNAME | SIZE | COLOR | PRICE | DOP |
| C001 | JEANS | XL | BLUE | 990 | 2022-01-21 |
| C002 | T-SHIRT | M | RED | 599 | 2021-12-12 |
| C003 | TROUSER | M | GREY | 399 | 2021-11-10 |
| C004 | SAREE | FREE | GREEN | 1299 | 2019-11-12 |
| C005 | KURTI | L | WHITE | 399 | 2021-12-07 |
- Write a query to display cloth names in lowercase.
- Write a query to display the lowest price of the clothes.
- Write a query to count the total number of clothes purchased in medium size.
OR
Write a query to count the year-wise total number of clothes purchased.
Which function returns the sum of all elements of a list?
