To create more powerful SQL queries, you can use special clauses and operators. When you want to filter the data and show only specific records that meet certain conditions, you must use the ____ clause. For example, you can use it to display only students from a certain class or only those older than a certain age. If you want to display your query results in a specific order — such as alphabetically by name or from youngest to oldest — you use the ____ clause. By default, this clause sorts the results in ____ order (from A to Z or from smallest to largest). If you want to sort in reverse order, such as Z to A or from highest to lowest number, you must use the keyword ____. Sometimes, you don’t want to write many OR conditions in a WHERE clause. Instead, you can use the ____ operator to check whether a value appears in a specific list. For example, you can select students who are in classes ‘6B’, ‘7A’, or ‘8C’. When you want to find values that fall between two numbers (for example, ages from 12 to 14), you can use the ____ operator.

SQL WHERE & ORDER BY basics

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?