implant


  Aktif KonularAktif Konular  Forum Üyelerini GösterÜye Listesi  Forumu AraArama  YardımYardım
  Kayıt OlKayıt Ol  GirişGiriş
ASP / ASP.NET
 ASPTurkiye.com Forum : ASP / ASP.NET
Konu Konu: veri çekme yardım Yanıt YazYeni Konu Gönder
Yazanlarda
Mesaj << Önceki Konu | Sonraki Konu >>
vuralcankurt
Yeni Üye
Yeni Üye


Kayıt Tarihi: 26-Ağustos-2012
Gönderilenler: 2
Gönderen: 10-Kasım-2012 Saat 12:07 | Kayıtlı IP Alıntı vuralcankurt

selamlar arkadaşlar

şirket ismi         personel ismi              yaptığı satış

A  şirketi          ; ;    süleyman                    45

a şirketi              süleyman                    30

A şirketi              ahmet         & amp; amp; amp; nbsp;         & amp; amp; amp; nbsp;    50

b şirketi              ahmet                         60

şeklinde bir veri tablom var A şirketindeki personellerin isim isim toplam satışlarını alabiliyorum. Bana A şirketinde , B şirketinde C şirketinde satış yapan personellerin toplam en fazla satış yapanını gösterecek kodu yapamıyorum. fikir verirseniz sevinirim

mesala A şirketi:süleyman

b şirketi:ahmet gibi

şimdiden teşekkürler.(veri tabanı access)

<%set rs= server.createobject("adodb.recordset")
sql = "SELECT adsoyad,SUM(toplam_satis) as toplam_satis,sirket,adsoyad FROM satis_tablosu GROUP BY adsoyad,sirket,toplam_satis"
rs.open sql, veritabani_baglanti, 1, 3
%>
<%=rs("sirket")%>
<%=rs("adsoyad")%>
<%=rs("toplam_satis")%>
<%%>



Düzenleyen vuralcankurt 10-Kasım-2012 Saat 12:34
Yukarı Dön Göster vuralcankurt's Özellikler Diğer Mesajlarını Ara: vuralcankurt
 
mrkorkan
Kıdemli Üye
Kıdemli Üye


Kayıt Tarihi: 24-Ağustos-2013
Ülke: Turkiye
Gönderilenler: 126
Gönderen: 02-Haziran-2014 Saat 09:14 | Kayıtlı IP Alıntı mrkorkan

birşeyler yazılmış ama anlamadım
Yukarı Dön Göster mrkorkan's Özellikler Diğer Mesajlarını Ara: mrkorkan
 
yazlık
Üye
Üye


Kayıt Tarihi: 24-Haziran-2014
Ülke: Türkiye
Gönderilenler: 42
Gönderen: 26-Haziran-2014 Saat 15:19 | Kayıtlı IP Alıntı yazlık

neden yabancı yazılar
Yukarı Dön Göster yazlık's Özellikler Diğer Mesajlarını Ara: yazlık
 
collegefootball
Üye
Üye


Kayıt Tarihi: 23-Şubat-2024
Gönderilenler: 85
Gönderen: 28-Nisan-2024 Saat 04:12 | Kayıtlı IP Alıntı collegefootball

<a href="https://www.lsujerseyshop.com/shop-by-players-
ali-gaye-jersey-c-1_28.html" target="_blank"><b>Ali Gaye
LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
al-woods-jersey-c-1_86.html" target="_blank"><b>Al Woods
LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
anthony-bradford-jersey-c-1_76.html" target="_blank">
<b>Anthony Bradford LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
arden-key-jersey-c-1_66.html" target="_blank"><b>Arden
Key LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
austin-deculus-jersey-c-1_77.html" target="_blank">
<b>Austin Deculus LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
badara-traore-jersey-c-1_75.html" target="_blank">
<b>Badara Traore LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
billy-cannon-jersey-c-1_41.html" target="_blank"><b>Billy
Cannon LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
bj-ojulari-jersey-c-1_35.html" target="_blank"><b>BJ
Ojulari LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
blake-ferguson-jersey-c-1_64.html" target="_blank">
<b>Blake Ferguson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
brad-wing-jersey-c-1_60.html" target="_blank"><b>Brad
Wing LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
bradyn-swinson-jersey-c-1_32.html" target="_blank">
<b>Bradyn Swinson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
breiden-fehoko-jersey-c-1_83.html" target="_blank">
<b>Breiden Fehoko LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
brian-thomas-jr-jersey-c-1_29.html" target="_blank">
<b>Brian Thomas Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
chasen-hines-jersey-c-1_68.html" target="_blank">
<b>Chasen Hines LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
clyde-edwardshelaire-jersey-c-1_44.html" target="_blank">
<b>Clyde Edwards-Helaire LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
colby-richardson-jersey-c-1_45.html" target="_blank">
<b>Colby Richardson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
cordale-flott-jersey-c-1_52.html" target="_blank">
<b>Cordale Flott LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
damien-lewis-jersey-c-1_71.html" target="_blank">
<b>Damien Lewis LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
damone-clark-jersey-c-1_36.html" target="_blank">
<b>Damone Clark LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
danielle-hunter-jersey-c-1_85.html" target="_blank">
<b>Danielle Hunter LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
darran-evans-jersey-c-1_48.html" target="_blank">
<b>Darran Evans LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
darrel-williams-jersey-c-1_54.html" target="_blank">
<b>Darrel Williams LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
davon-godchaux-jersey-c-1_69.html" target="_blank">
<b>Davon Godchaux LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
deion-jones-jersey-c-1_62.html" target="_blank"><b>Deion
Jones LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
derek-stingley-jr-jersey-c-1_49.html" target="_blank">
<b>Derek Stingley Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
devin-white-jersey-c-1_61.html" target="_blank"><b>Devin
White LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
dj-chark-jersey-c-1_17.html" target="_blank"><b>DJ Chark
LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
donte-jackson-jersey-c-1_2.html" target="_blank"><b>Donte
Jackson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
duke-riley-jersey-c-1_12.html" target="_blank"><b>Duke
Riley LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
ed-ingram-jersey-c-1_72.html" target="_blank"><b>Ed
Ingram LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
ethan-pocic-jersey-c-1_78.html" target="_blank"><b>Ethan
Pocic LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
foster-moreau-jersey-c-1_37.html" target="_blank">
<b>Foster Moreau LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
garrett-nussmeier-jersey-c-1_31.html" target="_blank">
<b>Garrett Nussmeier LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
grant-delpit-jersey-c-1_18.html" target="_blank"><b>Grant
Delpit LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
gregory-clayton-jr-jersey-c-1_80.html" target="_blank">
<b>Gregory Clayton Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jabril-cox-jersey-c-1_39.html" target="_blank"><b>Jabril
Cox LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jacob-phillips-jersey-c-1_15.html" target="_blank">
<b>Jacob Phillips LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jalen-mills-jersey-c-1_55.html" target="_blank"><b>Jalen
Mills LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jamal-adams-jersey-c-1_58.html" target="_blank"><b>Jamal
Adams LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jamarr-chase-jersey-c-1_3.html" target="_blank">
<b>Ja'Marr Chase LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jaquelin-roy-jersey-c-1_87.html" target="_blank">
<b>Jaquelin Roy LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jaray-jenkins-jersey-c-1_26.html" target="_blank">
<b>Jaray Jenkins LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jarrick-bernardconverse-jersey-c-1_50.html"
target="_blank"><b>Jarrick Bernard-Converse LSU Tigers
Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jayden-daniels-jersey-c-1_14.html" target="_blank"><b>Jay
Ward LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jay-ward-jersey-c-1_13.html" target="_blank"><b>Jayden
Daniels LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jeremiah-hughes-jersey-c-1_57.html" target="_blank">
<b>Jeremiah Hughes LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jerry-stovall-jersey-c-1_42.html" target="_blank">
<b>Jerry Stovall LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
joe-burrow-jersey-c-1_25.html" target="_blank"><b>Joe
Burrow LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
jontre-kirklin-jersey-c-1_30.html" target="_blank">
<b>Jontre Kirklin LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
justin-jefferson-jersey-c-1_5.html" target="_blank">
<b>Justin Jefferson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kaleb-jackson-jersey-c-1_56.html" target="_blank">
<b>Kaleb Jackson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kayshon-boutte-jersey-c-1_19.html" target="_blank">
<b>Kayshon Boutte LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kevin-toliver-ii-jersey-c-1_6.html" target="_blank">
<b>Kevin Toliver II LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
klavon-chaisson-jersey-c-1_38.html" target="_blank">
<b>K'Lavon Chaisson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kristian-fulton-jersey-c-1_4.html" target="_blank">
<b>Kristian Fulton LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kwon-alexander-jersey-c-1_53.html" target="_blank">
<b>Kwon Alexander LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kylin-jackson-jersey-c-1_47.html" target="_blank">
<b>Kylin Jackson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
kyren-lacy-jersey-c-1_8.html" target="_blank"><b>Kyren
Lacy LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
lael-collins-jersey-c-1_73.html" target="_blank"><b>La'el
Collins LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
leonard-fournette-jersey-c-1_20.html" target="_blank">
<b>Leonard Fournette LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
lloyd-cushenberry-jersey-c-1_79.html" target="_blank">
<b>Lloyd Cushenberry LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
logan-diggs-jersey-c-1_11.html" target="_blank"><b>Logan
Diggs LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
malik-nabers-jersey-c-1_24.html" target="_blank"><b>Malik
Nabers LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
mekhi-garner-jersey-c-1_7.html" target="_blank"><b>Mekhi
Garner LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
micah-baskerville-jersey-c-1_46.html" target="_blank">
<b>Micah Baskerville LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
mike-jones-jr-jersey-c-1_40.html" target="_blank"><b>Mike
Jones Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
neil-farrell-jersey-c-1_84.html" target="_blank"><b>Neil
Farrell LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
noah-cain-jersey-c-1_43.html" target="_blank"><b>Noah
Cain LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
odell-beckham-jr-jersey-c-1_9.html" target="_blank">
<b>Odell Beckham Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
patrick-peterson-jersey-c-1_21.html" target="_blank">
<b>Patrick Peterson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
patrick-queen-jersey-c-1_23.html" target="_blank">
<b>Patrick Queen LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
racey-mcmath-jersey-c-1_34.html" target="_blank"><b>Racey
McMath LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
rashard-lawrence-jersey-c-1_82.html" target="_blank">
<b>Rashard Lawrence LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
reid-ferguson-jersey-c-1_65.html" target="_blank"><b>Reid
Ferguson LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
russell-gage-jersey-c-1_81.html" target="_blank">
<b>Russell Gage LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
stephen-sullivan-jersey-c-1_27.html" target="_blank">
<b>Stephen Sullivan LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tashawn-bower-jersey-c-1_63.html" target="_blank">
<b>Tashawn Bower LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
terrace-marshall-jr-jersey-c-1_16.html" target="_blank">
<b>Terrace Marshall Jr. LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tommy-casanova-jersey-c-1_59.html" target="_blank">
<b>Tommy Casanova LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
trai-turner-jersey-c-1_67.html" target="_blank"><b>Trai
Turner LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tredavious-white-jersey-c-1_33.html" target="_blank">
<b>Tre'Davious White LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tyler-shelvin-jersey-c-1_74.html" target="_blank">
<b>Tyler Shelvin LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tyrann-mathieu-jersey-c-1_22.html" target="_blank">
<b>Tyrann Mathieu LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
tyrion-davisprice-jersey-c-1_10.html" target="_blank">
<b>Tyrion Davis-Price LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
will-clapp-jersey-c-1_70.html" target="_blank"><b>Will
Clapp LSU Tigers Jerseys</b></a>
<a href="https://www.lsujerseyshop.com/shop-by-players-
zy-alexander-jersey-c-1_51.html" target="_blank"><b>Zy
Alexander LSU Tigers Jerseys</b></a>
Yukarı Dön Göster collegefootball's Özellikler Diğer Mesajlarını Ara: collegefootball
 
312webtasarim
Yeni Üye
Yeni Üye


Kayıt Tarihi: 29-Kasım-2022
Ülke: Türkiye
Gönderilenler: 2
Gönderen: 01-Mayıs-2024 Saat 12:16 | Kayıtlı IP Alıntı 312webtasarim

Toplam satış için;
SELECT personel_ismi, sirket_ismi, SUM(satis_miktari) AS
toplam_satis
FROM satis_verileri
GROUP BY personel_ismi, sirket_ismi;



en çok atışı yaparn personel

SELECT sirket_ismi, personel_ismi, MAX(toplam_satis) AS
en_fazla_satis
FROM personel_satislari
GROUP BY sirket_ismi;

__________________
www.312webtasarim.com
Yukarı Dön Göster 312webtasarim's Özellikler Diğer Mesajlarını Ara: 312webtasarim Ziyaret 312webtasarim's Ana Sayfa
 

Eğer Bu Konuya Cevap Yazmak İstiyorsanız İlk Önce Giriş
Eğer Kayıtlı Bir Kullanıcı Değilseniz İlk Önce Kayıt Olmalısınız

  Yanıt YazYeni Konu Gönder
Yazıcı Sürümü Yazıcı Sürümü

Forum Atla
Kapalı Foruma Yeni Konu Gönderme
Kapalı Forumdaki Konulara Cevap Yazma
Kapalı Forumda Cevapları Silme
Kapalı Forumdaki Cevapları Düzenleme
Kapalı Forumda Anket Açma
Açık Forumda Anketlerde Oy Kullanma

Powered by Web Wiz Forums version 7.91
Copyright ©2001-2004 Web Wiz Guide

Bu Sayfa 0,0780 Saniyede Yüklendi.