SQL CASE statement - Introduction and syntax
The answers to following questions will be made available soon. Keep
visiting.
Explain the SQL CASE statement. Write SQL syntax for the SQL CASE statement
along with an example.
GROUP BY: It is used with aggregate functions to group the result-set by one or
more columns................
LIKE clause is used for pattern matching. % is used to match any string of any
length where as _ allows you to match on a single character................
SQL NOT NULL: The NOT NULL constraint enforces a column to NOT accept NULL
values..............
SQL SELECT INTO: The SELECT INTO statement selects data from one table and
inserts it into a different table. Used often for creating back
up’s............
|
