Tiêu đề Chap2_Basic Select.pdf ✅

Chapter 2 Retrieving Data Using the SQL SELECT Statement Issue No./ Date : 01 / August. 06, 2023 Revision No. & Date : 00 / August. 06, 2023 Copyright © 2023, SEED Infotech Ltd. Pune, India. All rights reserved.
Objectives ▪ After completing this lesson, you should be able to do the following: ▪ List the capabilities of SQL SELECT statements ▪ Execute a basic SELECT statement
Basic SELECT Statement ▪ SELECT identifies the columns to be displayed. ▪ FROM identifies the table containing those columns. SELECT *|{[DISTINCT] column [alias],...} FROM table;
Selecting All Columns SELECT * FROM departments;