Folks
I have two select statements which gives two counts ie two numbers.
select 'count' = count(*) from account
select 'count1' = count(*) from employee
I want to combine these two select statements and write one select statement where I can get two columns 'count' and 'count1' with the respective values.
The result should be EX:
count count1
3 5
Thanksselect (select count(*) from account) as 'Count',
(select count(*) from employee) as 'Count1'
No comments:
Post a Comment