Overview of the ORDER BY Clause in SQL This blog post shows you how to use the ORDER BY clause in SQL to sort the result set of a query. When viewing the result set of a SELECT statement in SQL, the records appear in the order that they were selected from the table.
Buy Introductory SQL Quick Reference Cards at TeachUcomp, Inc. with Our New Product Release, the “Introductory SQL Quick Reference Guide!” You can now buy Introductory SQL quick reference cards with our new “Introductory SQL Quick Reference Guide” product. This Introductory SQL quick reference card is a great reference tool for both database pros and
The DROP Statement in SQL: Overview You use the DROP statement in SQL to delete created database objects. You can use the DROP statement in SQL to delete databases, tables and indexes. You can also use the DROP statement in SQL in conjunction with the ALTER TABLE statement to delete fields
NULL Values in SQL: Overview When creating tables in SQL, you will need to deal with NULL values in SQL. A NULL value is a value that is unknown. These values can occur within database tables when a user who is performing data entry skips entering a value into a field. When a value
The UPDATE Statement in SQL: Overview After you have data within the tables in your database, you will often need to update those records. SQL uses the UPDATE statement to update field data within specified records in a table. The core SQL of the UPDATE statement is shown below. Note that the “table_name” parameter
The SELECT Statement in SQL: Overview You use the SELECT statement in SQL to choose specific records to view from a table, or from related tables, within a temporary table called a result set. We will start the examination of the SELECT statement by looking at the SELECT statement in its simplest form when
CREATE DATABASE Statement: Overview Within many relational database management systems, the CREATE DATABASE statement is used to create the database. The core SQL of the statement is shown below. CREATE DATABASE database_name In this statement, the “database_name” parameter is the name you want to give to the database. Note that while most versions
The UNION Operator in SQL: Overview The UNION operator in SQL allows you to combine the result sets of two or more individual SELECT statements into a single result set. Note that the UNION operator in SQL is not a JOIN, but rather a way to combine the data within two result sets into