'Valid search string values' presentation slideshows

3.04k views • 278 slides

Writing Basic SQL SELECT Statements

Writing Basic SQL SELECT Statements. Capabilities of SQL SELECT Statements. Projection. Selection. Table 1. Table 1. Join. Table 2. Table 1. Basic SELECT Statement. SELECT identifies what columns FROM identifies which table.

604 views • 48 slides

Queries

Queries. SELECT [DISTINCT] <columnlist> FROM ( <table-list> {<alias>}| <joined table>),... [WHERE <condition>] [GROUP BY <grouping columns> [HAVING <group selection condition>]] [ORDER BY <column name> [<order>],...]. The Basic Query Block.

720 views • 44 slides

Restricting and Sorting Data

Restricting and Sorting Data. Ceng 356-Lab2. Objectives. After completing this lesson, you should be able to do the following: Limit the rows that are retrieved by a query Sort the rows that are retrieved by a query Use ampersand substitution to restrict and sort output at run time.

469 views • 36 slides

Restricting and sorting data

504 views • 27 slides

Limiting Rows Using a Selection

290 views • 23 slides