How to rename result set of COUNT(*) in SQL

sql sql-server

SELECT count(*) AS numcustomers FROM CustomersWHERE Country = 'USA'

Use AS keyword to set column alias.

sql sql-server

Akshey Bhat is right

SELECT     count(*) AS numcustomers FROM CustomersWHERE Country = 'USA'

This query to get a number of usa customer and this index name is numcustomers or column name is numcustomers

sql sql-server

SELECT COUNT(*) AS NUMCUSTOMERS FROM CUSTOMERSWHERE COUNTRY = 'USA'

CodeHunter