SQL5 03 SQL: Intermediate_Aggregate Functions Projects and Applications 보호되어 있는 글 입니다. 2023. 2. 12. 02 SQL: Basics_Writing Queries (3) (source: Codecademy, https://www.codecademy.com) LIMIT : specify the maximum number of rows the result set will have CASE : create different outputs (usually in the SELECT statement) Each WHEN tests a condition and the following THEN gives us the string if the condition is true The ELSE gives us the string if all the above conditions are false The CASE statement must end with END Rename the whol.. 2023. 2. 11. 02 SQL: Basics_Writing Queries (2) (source: Codecademy, https://www.codecademy.com) BETWEEN : filter the result set within a certain range BETWEEN two letters is not inclusive of the 2nd letter BETWEEN two numbers is inclusive of the 2nd number AND : combine multiple conditions AND operator displays a row if all the conditions are true OR : combine multiple conditions OR operator displays a row if any condition is true ORDER BY :.. 2023. 2. 10. 02 SQL: Basics_Writing Queries (1) (source: Codecademy, https://www.codecademy.com) - 데이터 총 230개 - id, name, genre, year, imdb_rating SELECT name, genre FROM movies; select individual columns by their names AS : rename a column or table using an alias When using AS, the columns are not being renamed in the table. The aliases only appear in the result. - name 부분이 Title 로 바뀜 (결과 부분에서만 그렇게 나타나도록 한 것, 실제로 바뀐 건 아님) DISTINCT : filters .. 2023. 2. 5. 01 Introduction to SQL (source: Codecademy, https://www.codecademy.com) SQL, Structured Query Language What is a Relational Database? A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables. What is a Relational Database Management System (RDBMS)? A rel.. 2023. 2. 4. 이전 1 다음
