SQL Cookbook: Retrieving Records

1, where clause, and priority is higher than or

1 Select *  from where < Ten or  like ' %ark '  and = \g

is equivalent to the following query:

1 Select *  from where < Ten or  like ' %ark '  and = ) \g

2. Connection column value: concat

1 Select concat (" " as from Film\g

3. Use Case statements

1 Selecttitle,2  Case 3      whenLength<=  -  Then ' Short' 4      whenLength>  -  Then 'Long' 5 End 6  asInfo fromFilmwherefilm_id= 1\g

4. Randomly select N data

1 Select  from Order  by Rand 5\g

5. Find empty values

1 Select  from where  is NULL\g

Null to use is

6. Set default values for null values

1 Select COALESCE "'  as  from Film\g

SQL Cookbook: Retrieving Records