rank() over (order by bushels asc) as rank, dense_rank() over (order by bushels asc) as dense_rank, row_number() over (order by bushels) as row_number, rank() over ...

SELECT employee_id, first_name, last_name, job_id, salary, FIRST_VALUE(CONCAT(first_name, ' ', last_name)) OVER (PARTITION BY job_id ORDER BY salary DESC) AS HIGHEST ...

This article is also available as a download, SQL injection attacks: A cheat sheet for business pros ... Depending on the kind of escape function used, SQL input statements will be edited to ...