----+---------+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; city you do SELECT * FROM weather 9 Chapter 2. The SQL Language ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; city qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 15 Chapter 3. Advanced Features 3.1. Introduction In the previous

----+---------+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; city always get the results shown above if you do SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; city qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 14 Chapter 3. Advanced Features 3.1. Introduction In the previous

----+---------+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; city if you do 9 Chapter 2. The SQL Language SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; city qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 15 Chapter 3. Advanced Features 3.1. Introduction In the previous

----+---------+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; city if you do 9 Chapter 2. The SQL Language SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; city qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 15 Chapter 3. Advanced Features 3.1. Introduction In the previous

----+---------+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; city if you do 9 Chapter 2. The SQL Language SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; city qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 15 Chapter 3. Advanced Features 3.1. Introduction In the previous

--+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; above if you do: 11 The SQL Language SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 17 Chapter 3. Advanced Features 3.1. Introduction In the previous

--+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; the results shown above if you do: SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 16 Chapter 3. Advanced Features 3.1. Introduction In the previous

--+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; the results shown above if you do: SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 15 Chapter 3. Advanced Features 3.1. Introduction In the previous

--+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; the results shown above if you do: SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 14 Chapter 3. Advanced Features 3.1. Introduction In the previous

--+------+------------ San Francisco | 46 | 50 | 0.25 | 1994-11-27 (1 row) You can request that the results of a query be returned in sorted order: SELECT * FROM weather ORDER BY city; above if you do: 11 The SQL Language SELECT * FROM weather ORDER BY city, temp_lo; You can request that duplicate rows be removed from the result of a query: SELECT DISTINCT city FROM weather; qualification, DELETE will remove all rows from the given table, leaving it empty. The system will not request confirmation before doing this! 17 Chapter 3. Advanced Features 3.1. Introduction In the previous