Total number of eligible records in the SQL query database _mssql

1. Select COUNT (*) from table; Number of statistical tuples

2. Select count (column name) from table; Count the number of values in a column

3. Select COUNT (*) from table where field = ""; Total number of records that meet the criteria

4. Sql_count = "SELECT count (*) from article a Where 1=1";

In this statement, a represents the article table, which can be followed by a. field that represents the table's fields, where 1 = 1, which is equivalent to providing a where. Because 1=1 is always set up.

You can add and a. field = "", and so on, depending on whether you need to add a condition.

Cases:

Sql_count = "SELECT count (*) from article a where 1=1";
if (! "". Equals (title) && title!=null) {
Sql_count + = "and a.a_title like '%" +title+ "%"; 
}

The above is a small series to introduce the SQL query database to meet the requirements of the total number of records, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!