|

|

VerySource»Forum › Database › MS-SQL Server › The difference between count (*) and count (1)

Return to list New

View: 681|Reply: 1

The difference between count (*) and count (1)

1 Threads	1 Posts	2.00 Credits

Rank: 1

Credits: 2.00

Send PM

China

Post time: 2020-1-30 15:40:01
| Show all posts |Read mode

I am a novice and hope to get your advice, thank you.

Reply

Use magic Report

0 Threads	28 Posts	25.00 Credits

Rank: 1

Credits: 25.00

Send PM

United States

Post time: 2020-3-7 19:30:01
| Show all posts

According to the test results, there is no difference in performance, and the execution plan is the same, just different.

Reply

Use magic Report

Return to list New

Contact us|Archive|Mobile|CopyRight © 2008-2023|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list