sql server - Is this 'tip' about the distinct function outdated? -


So, according to 2007, we should not use different as a code, I.e. not

  choose separately (employee id), salary from salaried   

is it still true?

DISTINCT is not a function

Select after the keyword different after the column expression (employeeID) .

To make things more clear, the following three things are the same:

  • Choose different employee ID (pay)
  • Li>
  • Select employee id and (employee id) the same thing: a reference to the column.

Comments