Best Java, SQL Development and SQL Server DBA Training Institute in Bangalore

The Crystalspiders is an online & class room IT training institute based out of Bangalore, India which has been taken a major step to provide world class, highly real-time and practical training in the various database technologies to the fresher graduate, post graduate students and employees across the globe. We are currently providing training in Java Full Stack, SQL Server DBA, MSBI, T-SQL, Hadoop Bigdata Development and Administration, PostgreSQL Admin, PLSQL and Oracel DBA.

Showing posts with label SQL DBA REALTIME TRAINING. Show all posts

Tuesday, 21 February 2017

What is the difference between count(1) and count(*) in SQL Server?

The count(1) refers the count of records in the first column. If there are any null values in the first column, it won't count that record.
The count(*) refers the count of records on overall the columns. It will display the no.of records.

Thanks

Pages

Tuesday, 21 February 2017

What is the difference between count(1) and count(*) in SQL Server?