SELECT, SQL Simantics

Using Expressions in a SELECT FROM DUAL

Randy Sims SQL Fundamentals I

Exam Topic: Retrieving Data Using the SQL SELECT Statement – Execute a basic SELECT statement In The Capabilities of a SELECT Statement, we talked about returning columns from a table using the SELECT list and a few of the alternatives. In fact, any expression you can think of can be in the SELECT list. An expression is “a combination of one […]

Restricting Data – Selection in the WHERE Clause

Randy Sims SQL Fundamentals I

Exam Topic: Restricting and Sorting Data – Limit the rows that are retrieved by a query Returning the right data by restricting rows to answer questions is at the heart of SQL Development. As shown in The Capabilities of a SQL SELECT Statement, the WHERE clause is used to specify conditions for which rows should be returned. If the […]

The Capabilities of a SQL SELECT Statement

Randy Sims SQL Fundamentals I

Exam Topic: Retrieving Data Using the SQL SELECT Statement – List the capabilities of SQL SELECT statements By far, the most important skill for anyone to possess when working with a database is the skill to extract from the database the data you want in the format you desire. The SELECT statement, therefore, is the most important […]