SELECT COUNT(*) ;
06:08 06 Dec 2011

I have a database, database1, with two tables (Table 1, Table2) in it.

There are 3 rows in Table1 and 2 rows in Table2. Now if I execute the following SQL query SELECT COUNT(*); on database1, then the output is "1".

Does anyone has the idea, what this "1" signifies?

The definition of the two tables is as below.

CREATE TABLE Table1 (
    ID INT PRIMARY KEY,
    NAME NVARCHAR(20)
)

CREATE TABLE Table2 (
    ID INT PRIMARY KEY,
    NAME NVARCHAR(20)
)
sql sql-server select count