How to Use the ORDER BY Clause in SQL
Monday, August 30 2021
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.
- Published in Access 2019, Access for Office 365, Latest, Microsoft, Office 2019, Office 365, SQL
No Comments
Buy Introductory SQL Quick Reference Cards
Friday, July 09 2021
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
- Published in Latest, Marketing, News, SQL, What's New at TeachUcomp?
The DROP Statement in SQL – Tutorial
Thursday, July 14 2016
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
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
NULL Values in SQL – Tutorial
Tuesday, April 12 2016
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
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
The UPDATE Statement in SQL- Tutorial
Wednesday, October 28 2015
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
- Published in Access 2013, Latest, Microsoft, Office 2013, SQL
The SELECT Statement in SQL- Tutorial
Monday, September 21 2015
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
- Published in Access 2010, Access 2013, Latest, Microsoft, Office 2010, Office 2013, SQL
CREATE DATABASE Statement- Tutorial
Friday, June 26 2015
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- Tutorial
Wednesday, February 11 2015
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
- Published in Access 2013, Latest, Office 2013, SQL
- 1
- 2