select first_name,upper(first_name),lower(first_name),initcap(first_name), length(first_name),reverse(first_name) from employees; select * from employees where first ...
- Act on one row at a time and return a single value. - UPPER / LOWER and CONCAT are examples of SRFs. - SRFs don't necessarily always have to be in SELECT clauses. They can also be in WHERE clauses ...