how to select value only if it appears more than once without count

+2 tal barak · November 20, 2015
hello, how do i select value from coloumn where value apears more then once? 
this is home work for school so i cant use count\group by\having cause we didnt study this yet... 

champion_yearcountry_codecoach_code
198310040
199030040
200230030
200410010
200510010

i need a query that gives a table of the coach_code that won more than one time
so i would get:
coach_code
40
30

how??? thank you

Post a Reply

Replies

Oldest  Newest  Rating
0 Arira joseph · July 8, 2016
Looking at your table, no specific info abt any coach is given making it hard to list out the particular coach that won more than once
0 sfolje 0 · July 25, 2016
did you mean this? :
40
10

I guess home work is over :D
  • 1

SQL & Databases

107,055 followers
About

Everything SQL and Databases related in here!

Links
Moderators
Bucky Roberts Administrator