MySQL Forums
Forum List  »  Turkish

Re: Aynı tablo üzerindeki aynı ID li satırları işaretlemek
Posted by: Gokhan Sogutcu
Date: January 21, 2010 05:13AM

tablo adinin uye oldugunu varsayarak,

select t1.uye_no,t1.tani_kodu,t1.yil,t2.adet from uye t1
left join (select count(*) as adet,uye_no,yil from uye group by uye_no,yil) t2
ON t1.uye_no=t2.uye_no;

sorgusu isini gorur sanirim.



Edited 1 time(s). Last edit at 01/21/2010 05:15AM by Gokhan Sogutcu.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Aynı tablo üzerindeki aynı ID li satırları işaretlemek
4199
January 21, 2010 05:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.