Informatics Practices
Identify the Single Row function of MySQL among the following:
- Trim ()
- Max ()
- Avg()
- Count()
SQL Queries
1 Like
Answer
Trim()
Reason — Trim() is a single row function that removes leading and trailing spaces from a string.
Answered By
3 Likes
Related Questions
In the table 'Student' in MySQL, if column 'Fees' contains the data (5000, 8000, 7500, NULL, 5000, 8000), what will be the output after the execution of the given query?
SELECT COUNT(DISTINCT Fees) FROM student;Online …………… is a theft of personal information in order to commit a fraud.
What will be returned by the given query?
select round(23456.1234, -2) ;- 23456.00
- 23400
- 23500
- 23456.1200
Which one of the following functions is used to find the smallest value from the given data in MySQL?
- MIN()
- MINIMUM()
- SMALL()
- SMALLEST()