http://sqlserver.ro/forums/50/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/8422.aspxTue, 31 Aug 2010 18:05:47 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8422ignatandrei0http://sqlserver.ro/forums/thread/8422.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=50&PostID=8422<br>select departament from departament<br>where Salariu&gt; 300<br>group by departament<br>having count(nume_angajat)&gt; 10<br><br>Totusi, pune mina pe o carte de sql (sau tutorial...)<br>http://sqlserver.ro/forums/thread/8421.aspxTue, 31 Aug 2010 16:49:31 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:8421SorinM0http://sqlserver.ro/forums/thread/8421.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=50&PostID=8421Salut,<br><br>Sunt nou pe acest forum.<br><br>Am urmatoarea problema careia nu ii dau de cap:<br><br>Se da tabela departament cu coloanele departament, nume_angajat, salariu.<br><br>Sa se afiseze departamentele unde numarul de angajati este mai mare de 10 iar salariu este mai mare de 300$.<br><br>Multumesc.<br>