help SQL query
Database
3
Posts
3
Posters
0
Views
1
Watching
-
I have table 1 and table 2. Click link show pic Table 1 - Table 2 I need help to create table 3 from table 1 and table 2 using SQL query
^_^_^
-
I have table 1 and table 2. Click link show pic Table 1 - Table 2 I need help to create table 3 from table 1 and table 2 using SQL query
^_^_^
No, you won't get many people to click some link. Please just put the relevant information in the question.
-
I have table 1 and table 2. Click link show pic Table 1 - Table 2 I need help to create table 3 from table 1 and table 2 using SQL query
^_^_^
With Numbering
As
(Select *,(case when len(phone) > 0 then 1
else 0
end) as Number
From dbo.table2)
select classid,count(student_name),sum(number)
from Numbering
group by classid;
