Advertisements
Advertisements
प्रश्न
Write suitable SQL query for the following:
Remove all the expected leading and trailing spaces from a column userid of the table ‘USERS’.
Advertisements
उत्तर
select trim(userid) from users;
APPEARS IN
संबंधित प्रश्न
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)
The char() function in MySql is an example of ______.
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 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) = ______.
"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.
Which of the following is not a text function?
Which function will be used to remove only the trailing spaces from a string?
Which statement is used to count the number of rows in table?
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 specified number of characters from a particular position of the given string.
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 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), MID("Informatics", 3, 4), SUBSTR("Practices", 3);
Which function is used to display the total number of records from a table in a database?
Write the outputs of the SQL queries based on the relations Teacher and Placement given below:
Table: Teacher
| T_ID | Name | Age | Department | Date_of_join | Salary | Gender |
| 1 | Arunan | 34 | Computer Sc | 2019-01-10 | 12000 | M |
| 2 | Saman | 31 | History | 2017-03-24 | 20000 | F |
| 3 | Randeep | 32 | Mathematics | 2020-12-12 | 30000 | M |
| 4 | Samira | 35 | History | 2018-07-01 | 40000 | F |
| 5 | Raman | 42 | Mathematics | 2021-09-05 | 25000 | M |
| 6 | Shyam | 50 | History | 2019-06-27 | 30000 | M |
| 7 | Shiv | 44 | Computer Sc | 2019-02-25 | 21000 | M |
| 8 | Shalakha | 33 | Mathematics | 2018-07-31 | 20000 | F |
Table: Placement
| P_ID | Department | Place |
| 1 | History | Ahmedabad |
| 2 | Mathematics | Jaipur |
| 3 | Computer Sc | Nagpur |
- SELECT Department, avg(salary) FROM Teacher GROUP BY Department;
- SELECT MAX(Date_of_Join), MIN(Date_of_Join) FROM Teacher;
- SELECT Name, Salary, T.Department, Place FROM Teacher T, Placement P WHERE T.Department = P.Department AND Salary>20000;
- SELECT Name, Place FROM Teacher T, Placement P WHERE Gender = ’F’ AND T.Department = P.Department;
Which one of the following is not an aggregate function?
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:
Round off the value 23.78 to one decimal place.
Explain the following SQL function using a suitable example.
UCASE()
Explain the following SQL function using a suitable example.
DAYNAME()
Explain the following SQL function using a suitable example.
POWER()
Which function returns the sum of all elements of a list?
