How to query the number of data records under a user in SQL Server?

2 years ago

Emily Johnson

1 minute

To retrieve the number of data records under a user, you can use the following SQL statement:

SELECT COUNT(*) FROM 表名 WHERE 用户ID = '用户ID';

Replace the table name and user ID in the above statement with the ones to be queried. After executing the SQL statement, it will return the number of data under that user.