MySQL Forums
Forum List  »  Turkish

Re: Aynı tablo üzerindeki aynı ID li satırları işaretlemek
Posted by: yerel haber
Date: February 09, 2010 09:20AM

bu durumlarda tablo adini uye oldugunu varsayacakssin

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;

isine yarayacakdir

www.bolgeselhaber.com
www.fatsahaber.org
www.sanalpsikologum.com
www.turkishrtv.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Aynı tablo üzerindeki aynı ID li satırları işaretlemek
3693
February 09, 2010 09:20AM


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.