RelationalDBDesign
SiteMap
Advanced SQL
Essential SQL
Interview Questions
Into Statement
«Prev
Next»
SQL Introduction
Course Prerequisites
Select Statement
What is SQL
Sample SQL Statement
Client/Server Request
SQL 92 (History)
SQL Dialect Variations
Database Setup
MS-SQL Server
SQL Module Review
Relational Databases
Relational vs Flatfile
Different Storage Formats
Relational DB Analogy
Database Normalization
Data Table Example
Normalization Example Table
Table Normalization - Exercise
Three Normalization Levels
Relational Flatfile DB
SQL Columns Rows
SQL Foundations
Database Elements
Database Spreadsheets
Database Parts - Quiz
Table Structure SQL
Create Table
Databases Column Types
Table Index
Create Index Column
Database Index Engine
Database Foundations - Quiz
SQL Insert
Incorrect Insert
SQL Select Statement
Selecting Information
Tables Rows Dsatabase
Querying XML
Table Querying
SQL Conclusion
INTO Statement
Order By Clause
SQL Into Statement
Filtering Select Statement
Joining Tables
Use SQL ORDER BY Clause - Exercise
Objective:
Given certain specifications, create a SELECT statement that correctly sorts the information in a table. Create a
SELECT
statement for the following table, named Orders:
OrderNum
ItemNum
Date
Qty
CustID
4332
1001
12/31/97
5
0001
4321
1001
01/10/98
1
1231
4332
1002
12/31/97
1
0001
4333
1003
01/15/98
1
0002
4321
1010
01/10/98
10
1231
4334
1011
01/10/98
1
1231
4335
1231
01/15/98
1
4325
4335
1001
01/15/98
1
4325
Submit
x