Ten
Common SQL Programming Mistakes :
The list of common mistakes
- NULLs
and the NOT IN predicate
- Functions
on indexed columns in predicates
- Incorrect
subquery column
- Data
type mismatch in predicates
- Predicate
evaluation order
- Outer
joins and placement of predicates
- Subqueries
that return more than one value
- Use
of SELECT *
- Scalar user-defined functions
- Overuse of cursors
For brief description please go through the below link
