Count Function

  • Retrieved the data using below mentioned two functions
  • (i)Count Function (ii) Left Function in SQL server

    •  

    Syntax: Select count(Item) as ItemsCount from Sales where left(Item, 1) = 'M'