Deleting Rows
メニューを表示するにはスワイプしてください
We can conditionally select and delete rows from a table using the DELETE statement.
Following is the syntax of the DELETE statement:
DELETE FROM table_name
WHERE condition;
The DELETE statement selects rows from table_name based on a condition and deletes them.
Example: Removing Graduated Students
Consider a table students with the following columns name, age, grade, score, and graduation_year.
We would like to delete all the rows from the table where the graduation_year is less or equal to 2024, since those students have already graduated and we no longer want to retain their data.
This can be done using the following query:
DELETE
FROM students
WHERE graduation_year <= 2024;
Demonstration:
すべて明確でしたか？
フィードバックありがとうございます！
セクション 5. 章 5
AIに質問する
AIに質問する
何でも質問するか、提案された質問の1つを試してチャットを始めてください
セクション 5. 章 5
