반응형
Hello SQL!
Return a table with a single column named Greeting with the phrase 'hello world!'
Please use Data Manipulation Language and not Data Definition Language to solve this Kata
Solution:
SELECT 'hello world!' AS "Greeting"
The reason 'Greeting' is enclosed in double quotation marks is that uppercase letters are changed to lowercase letters unless they are enclosed in double quotation marks.
Result:
Greeting |
hello world! |
반응형
'나는 이렇게 학습한다 > Algorithm & SQL' 카테고리의 다른 글
SQL Basics: Simple JOIN with COUNT (0) | 2022.07.19 |
---|---|
SQL Basics: Simple HAVING (0) | 2022.07.19 |
GROCERY STORE: Logistic Optimisation (0) | 2022.07.16 |
SQL: Regex Replace (0) | 2022.07.15 |
SQL Basics: Top 10 customers by total payments amount (0) | 2022.07.14 |