Advertisements
Advertisements
Question
Write suitable SQL query for the following:
Round off the value 23.78 to one decimal place.
Advertisements
Solution
select round(23.78,1);
APPEARS IN
RELATED QUESTIONS
______ is used to get a specified day of the month for a given date.
The MAX () function finds the
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?
The char() function in MySql is an example of ______.
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 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?
What will be returned by the given query? SELECT MID('BoardExamination', 2, 4) = ______.
Which of the following is not a date function?
What is the general format of UPPER() return type?
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 ROUND(342.9234, -1);
Write the output produced by the following SQL statement:
SELECT LENGTH("Informatics Practices");
Differentiate between count() and count(*) functions in SQL with appropriate examples.
Which type of values will not be considered by SQL while executing the following statement?
SELECT COUNT(column name) FROM inventory;
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:
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.
TRIM()
Explain the following SQL function using a suitable example.
POWER()
