Welcome to
Sign in
|
Help
in
SQL Server 2008 (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
SQL Server 2008
»
Re: Ajutor problema incepator!
Ajutor problema incepator!
Last post 08-31-2010, 9:05 PM by
ignatandrei
. 1 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
08-31-2010, 7:49 PM
8421
SorinM
Joined on 08-31-2010
db_datareader
Ajutor problema incepator!
Reply
Quote
Salut,
Sunt nou pe acest forum.
Am urmatoarea problema careia nu ii dau de cap:
Se da tabela departament cu coloanele departament, nume_angajat, salariu.
Sa se afiseze departamentele unde numarul de angajati este mai mare de 10 iar salariu este mai mare de 300$.
Multumesc.
Report abuse
08-31-2010, 9:05 PM
8422
in reply to
8421
ignatandrei
Joined on 11-17-2006
Bucuresti
sysadmin
Re: Ajutor problema incepator!
Reply
Quote
select departament from departament
where Salariu> 300
group by departament
having count(nume_angajat)> 10
Totusi, pune mina pe o carte de sql (sau tutorial...)
Ignat Andrei
http://serviciipeweb.ro/iafblog
Report abuse