I have a table that looks like this:
---------------------------------
Abc Qwe T 2
Abc Qwe P 3
Abc Qwe P 3
Abc Rty T 1
...I need to build an SQL SELECT statement that allows me to obain this result:
-----------------------------------
Abc Qwe 2 6
Abc Rty 1 0
...Is this possible?
I was thinking of something like:
FROM table
WHERE NoT=(SELECT...) AND NoP=(SELECT...)
GROUP BY Name, Subject
Code:
Name | Subject | Type | No. ---------------------------------
Abc Qwe T 2
Abc Qwe P 3
Abc Qwe P 3
Abc Rty T 1
...
Code:
Name | Subject | No. T | No. P -----------------------------------
Abc Qwe 2 6
Abc Rty 1 0
...
I was thinking of something like:
Code:
SELECT Name, Subject, NoT, NoP FROM table
WHERE NoT=(SELECT...) AND NoP=(SELECT...)
GROUP BY Name, Subject
Tricky column on select