+ 2

How to make Upper function?

19th Dec 2021, 12:13 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
22 Réponses
+ 8
Jamilu Abubakar Sadiq , I hope this link helps you https://code.sololearn.com/cxH4sC7i6aMZ
19th Dec 2021, 1:45 PM
SoloProg
SoloProg - avatar
+ 5
SELECT UPPER(CustomerName) AS UppercaseCustomerName, LOWER(CustomerName) AS LowercaseCustomerName FROM Customers;
19th Dec 2021, 12:25 PM
SoloProg
SoloProg - avatar
+ 3
SELECT answers FROM questions WHERE username LIKE '%SoloProg%'; -- Good Luck :)
19th Dec 2021, 12:46 PM
SoloProg
SoloProg - avatar
+ 2
There is an Upper function in most SQL systems.
19th Dec 2021, 12:23 PM
Alex
Alex - avatar
+ 2
in MySQL SELECT UCASE(CustomerName) AS Name FROM Customers;
19th Dec 2021, 1:14 PM
SoloProg
SoloProg - avatar
+ 2
-- try this: select SQRT(POWER(side_a, 2) + POWER(side_b, 2)) as side_c from triangle
19th Dec 2021, 2:26 PM
SoloProg
SoloProg - avatar
+ 2
Use UPPER (column_name)
21st Dec 2021, 1:30 AM
Andrea Raposo
Andrea Raposo - avatar
+ 1
insert into users (username) values ('SoloProg2'); insert into questions (username, answer) values ('SoloProg2', 'Good Luck :P');
19th Dec 2021, 12:50 PM
Alex
Alex - avatar
+ 1
Jamilu Abubakar Sadiq , yes
19th Dec 2021, 2:07 PM
SoloProg
SoloProg - avatar
+ 1
Thanks sir
19th Dec 2021, 2:12 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
+ 1
SELECT UPPER(column_name) from table_name; Select upper (column_name) as coustomer_name from table_name;
21st Dec 2021, 8:06 AM
Kamal Chamyal
Kamal Chamyal - avatar
0
Like which system
19th Dec 2021, 12:29 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
MySQL, Microsoft SQL Server, PostgreSQL, etc.
19th Dec 2021, 12:31 PM
Alex
Alex - avatar
0
Write a query to output the firstname and the lastname columns into one column named uppercasename separated by a space and converted to uppercase.
19th Dec 2021, 12:32 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
This is the project which I want to make it upper
19th Dec 2021, 12:33 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
SELECT answer FROM question WHERE username = 'SoloProg ' 😁
19th Dec 2021, 12:36 PM
Alex
Alex - avatar
0
In normal sql?
19th Dec 2021, 1:57 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
And what's about this question? Write a query to output a column named side_c where the hypotenuses of the corresponding rectangular triangles are shown.
19th Dec 2021, 2:13 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
The square of the hypotenuse is equal to the sum of the squares of the other two sides. Use the * operator for multiplication.
19th Dec 2021, 2:14 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar
0
You are given the following table named triangle with the values of 2 of the edges of rectangular triangles:
19th Dec 2021, 2:20 PM
Jamilu Abubakar Sadiq
Jamilu Abubakar Sadiq - avatar