View previous topic :: View next topic
|
Author |
Message |
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi,
Following are my table details:
Associate number - Asso_no
Associate code - asso_cde
dept - asso_dept
associate id - asso_id
As same associate id can have muliplte associate number. I want to query a table which results only those associate id and associate number having enrolled to DEPT = Physis more than once.
May you help with some suggestion |
|
Back to top |
|
|
mohitsaini Warnings : 1 New User
Joined: 15 May 2006 Posts: 92
|
|
|
|
SELECT asso_id, asso_no FROM mytable WHERE dept = Physics |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
|
|
did You understand the request ?
Did You test it ?
posting erroneous code is just a waste of time and resources |
|
Back to top |
|
|
krunalbafna Warnings : 1 Active User
Joined: 18 Jan 2010 Posts: 143 Location: Pune
|
|
|
|
Hi Mohit,
Thanks for above query.
But above query will results in output having associates enrolled in physis even once.
I am looking for such query which will result only those associate having enrolled in physis more than once.
Regards
Krunal |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Do some research on GROUP BY column HAVING COUNT(*) >1
That should serve your purpose. |
|
Back to top |
|
|
|