{"id":166,"date":"2022-05-25T22:39:27","date_gmt":"2022-05-25T19:39:27","guid":{"rendered":"http:\/\/www.cuneytbayrak.com\/?p=166"},"modified":"2025-02-21T00:36:19","modified_gmt":"2025-02-20T21:36:19","slug":"mssql-row_number-ve-partition-by-kullanimi","status":"publish","type":"post","link":"http:\/\/www.cuneytbayrak.com\/?p=166","title":{"rendered":"MSSQL Row_Number() ve Partition BY Kullan\u0131m\u0131"},"content":{"rendered":"

Bir projemde, sat\u0131\u015f yap\u0131lan firmalar\u0131n son 9 ayl\u0131k ald\u0131\u011f\u0131 \u00fcr\u00fcnlerin i\u00e7erisinde fiyat\u0131 en y\u00fcksek olan \u00fcr\u00fcnleri listelemem gerekti. Row_Number ve Partition By kullan\u0131m\u0131na g\u00fczel bir \u00f6rnek oldu.<\/p>\n

Sorgu Group By kullan\u0131larakta \u00e7\u00f6z\u00fclebilir pekala. Ancak Row_Number ve Partition By kullan\u0131m\u0131n\u0131 da bilmekte fayda var. Group By\u2019\u0131n \u00e7\u00f6z\u00fcm olamayaca\u011f\u0131 yerlerde imdada yeti\u015febilir.<\/p>\n

Row_Number ve Partition By kullan\u0131m\u0131:<\/strong><\/p>\n

\n
select * from (select ROW_NUMBER() over(partition BY (Tip+Izo+Cap+Boy) order by OzelFiyat desc) AS sira, Tip,Izo,Cap,Boy,OzelFiyat from ProformaVerileri\r\nwhere Tekliftarihi >= DATEADD(MONTH, -9, GETDATE()) and ProfNo like 'TAS%') k where sira=1 order by Tip\r\n<\/pre>\n<\/div>\n
Group By kullan\u0131m\u0131:<\/strong><\/p>\n
\n
select Tip,Izo,Cap,Boy,MAX(OzelFiyat) from ProformaVerileri where Tekliftarihi >= DATEADD(MONTH, -9, GETDATE()) and ProfNo like 'TAS%' GROUP BY Tip,Izo,Cap,Boy\r\n<\/pre>\n<\/div>\n
Kolay gele…<\/p>\n","protected":false},"excerpt":{"rendered":"
Bir projemde, sat\u0131\u015f yap\u0131lan firmalar\u0131n son 9 ayl\u0131k ald\u0131\u011f\u0131 \u00fcr\u00fcnlerin i\u00e7erisinde fiyat\u0131 en y\u00fcksek olan \u00fcr\u00fcnleri listelemem gerekti. Row_Number ve Partition By kullan\u0131m\u0131na g\u00fczel bir \u00f6rnek oldu. Sorgu Group By…<\/p>\n
Devam\u0131n\u0131 OkuMSSQL Row_Number() ve Partition BY Kullan\u0131m\u0131<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":0,"footnotes":""},"categories":[7],"tags":[42],"class_list":["post-166","post","type-post","status-publish","format-standard","hentry","category-mssql","tag-rownumberpartitionby","excerpt"],"_links":{"self":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=166"}],"version-history":[{"count":1,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/166\/revisions"}],"predecessor-version":[{"id":167,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=\/wp\/v2\/posts\/166\/revisions\/167"}],"wp:attachment":[{"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=166"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.cuneytbayrak.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}