Home >> SQL >> UPPER() aggregate function in SQL

UPPER() aggregate function in SQL

UPPER() Find all letters in lowercase.

Syntax

UPPER(column_name)

Example

SELECT UPPER('name') AS name FROM employee

Output

RAM

SHYAM

Post Your Comment

Next Questions
INITCAP() aggregate function
SUBSTR() aggregate function
ASCII() aggregate function
LENGTH() aggregate function
TRIM() aggregate function
LTRIM() aggregate function
RTRIM() aggregate function
Create database
Drop database
Select database
Create table
Drop table
Truncate table
Insert query
Select table
Where clause
AND Clause
OR Clause
Update query
Delete query
Like clause
IN clause
Order By
Group By
Distinct keyword

Copyright ©2022 coderraj.com. All Rights Reserved.