코드로 우주평화

Hello SQL World! 본문

나는 이렇게 학습한다/Algorithm & SQL

Hello SQL World!

daco2020 2022. 7. 17. 23:56

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
'나는 이렇게 학습한다/Algorithm & SQL' Related Articles more