SELECT COUNT(*) ;
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)
)