SQL: In, Between, Alias flash cards

Set: SQL: In, Between, Alias

Familiarize		Learn		Test
Play Scatter			Play Space Race

Term	Definition
SELECT column_name(s)FROM table_name WHERE column_name IN (value1,value2,...)	allows you to specify multiple values in a WHERE clause
SELECT column_name(s)FROM table_name WHERE column_name BETWEEN value1 AND value2	selects a range of data between two values. The values can be numbers, text, or dates.
SELECT column_name(s)FROM table_name AS alias_name	allows you to give a table or column another name

No Messages

Report as inappropriate