Create Table TBL1 (col1 int, col2 int)
Create Table TBL2 (col1 int, col2 int)
--query1
select count(col1) from TBL1 where col2 >= 5
--results
= 3
--query2
select count(col1) from TBL1 where col2 < 5
--results
= 2
-- can
you tell how many records are in the table?
-- how/why?
No comments:
Post a Comment