Quiz: COUNT() in SQL Server


Quiz: COUNT(WAT)

  • SELECT COUNT(PhoneNumber)
    FROM Application.People;
    GO
  • SELECT COUNT(*)
    FROM Application.People;
    GO
  • SELECT DISTINCT COUNT(PhoneNumber)
    FROM Application.People;
    GO
  • SELECT COUNT( DISTINCT PhoneNumber)
    FROM Application.People;
    GO