Alternatives
Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
20 Sep 2012Dave Kreskowiak
Permission granted! Please, proceed.Or did you have a question in there noboday can find?? What part of this are you having a problem with?Nobody is just going to give you code. This little assignment reeks of being homework and we're not here to do your homework for you so you can...
HiI just generated the sql query which yeilds the required result.SELECT Name, (SELECT COUNT(medal) FROM [TantraCAD].[dbo].[Sample] as Sample_1 Where Medal = 'Gold' and Sample_1.Name = Simplu.Name) AS "Gold", (SELECT COUNT(medal) FROM ...
use sql queryselect count(Columnname) from table group by (columnname)
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.