Advertisements
Advertisements
प्रश्न
Write suitable SQL query for the following:
Round off the value 23.78 to one decimal place.
Advertisements
उत्तर
select round(23.78,1);
APPEARS IN
संबंधित प्रश्न
______ is used to get a specified day of the month for a given date.
Which method is used to get the row-id of the last modified row?
Consider the table STUDENT given below:
| RollNo | Name | Class | DOB | Gender | City | Marks |
| 1 | Anand | XI | 6/6/97 | M | Agra | 430 |
| 2 | Chetan | XII | 7/5/94 | M | Mumbai | 460 |
| 3 | Geet | XI | 6/5/97 | F | Agra | 470 |
| 4 | Preeti | XII | 8/8/95 | F | Mumbai | 492 |
| 5 | Saniyal | XII | 8/10/95 | M | Delhi | 360 |
| 6 | Maakhiy | XI | 12/12/94 | F | Dubai | 256 |
| 7 | Neha | X | 8/12/95 | F | Moscow | 324 |
| 8 | Nishant | X | 12/6/95 | M | Moscow | 429 |
State the command to display the average marks scored by students of each gender who are in class XI?
(i) Select Gender, avg(Marks) from STUDENT where Class= "XI" group by Gender;
(ii) Select Gender, avg(Marks) from STUDENT group by Gender where Class="XI";
(iii) Select Gender, avg(Marks) group by Gender from STUDENT having Class="XI";
(iv) Select Gender, avg(Marks) from STUDENT group by Gender having Class = "XI";
Choose the correct option:
What will be the output of the following SQL statement?
SELECT DAY NAME (2022-04-08)
Assertion (A): COUNf function ignores DISTINCT
Reason (R): DISTINCT ignores the duplicate values.
Identify Single Row function of MySQL among the following.
What will be returned by the given query? select day of year('2015-02-10') = ______.
What will be returned by the given query? select power(3, 2) = ______.
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 DAYOFYEAR('2015-01-10') = ______.
Which function will be used to remove only the trailing spaces from a string?
What is the general format of UPPER() return type?
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 your name in capital letters.
Write the output produced by the following SQL statement:
SELECT ROUND(123.2345, 2),
ROUND(342.9234, −1);
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?
Which one of the following functions are used to find the largest value from the given data in MySQL?
In SQL, which function is used to display the current date and time?
Write suitable SQL query for the following:
Display 7 characters extracted from the 7th left character onwards from the string ‘INDIA SHINING’.
Explain the following SQL function using a suitable example.
UCASE()
Explain the following SQL function using a suitable example.
TRIM()
