T-SQL Tutorial

T-SQL Select Query

  • Group By - The GROUP BY is used when an aggregate function exists in the select query.
  • Having - Specifies a search condition for a group or an aggregate function.
  • Order By - Sort rows returned in an select query.
  • Where - Specifies a search condition for the rows returned by the select query.
  • Between - Returns rows if the value is within the range of comparisons.
  • Like – Returns rows if a character string matches a pattern.
  • Exists – Return rows if a subquery contains any rows.
  • In – Returns rows if a specified value matches any value in a subquery.
  • Some – Compares a value with a single column set of values.
  • Any – Returns rows if any value is equal to one value in a subquery.