Informatics Practices
What will be returned by the given query ?
SELECT month('2020-05-11');
- 5
- 11
- May
- November
SQL Queries
1 Like
Answer
5
Reason — The MONTH() function extracts the month component from a date passed. For the date '2020-05-11', since the month is 05, it returns 5.
Answered By
1 Like
Related Questions
What will be returned by the given query ?
SELECT Sign(26);- 1
- -1
- 0
- none of these
What will returned by the given query ?
SELECT Truncate(15.79, -1), Truncate(15.79, 0), Truncate(15.79, 1);- 15 15 15.7
- 10 15.7 15.9
- 10 15 15.7
- 10 10 15.9
Which of the following are correct aggregate functions in SQL ?
- AVERAGE()
- MAX()
- COUNT()
- TOTAL()
Write the output of the following SQL command :
SELECT Round(49.88);- 49.88
- 49.8
- 49.0
- 50