|
||
0
1
doctorgu
select a.Ä«Å×°í¸®, a.Á¦¸ñ from (select Ä«Å×°í¸®, Á¦¸ñ, row_number() over (partition by Ä«Å×°í¸® order by Ä«Å×°í¸®, Á¦¸ñ) as rnum from Å×À̺í) as a where a.rnum <= 2
Áö±Ý ¹ÛÀ̶ó È®ÀÎÀº ¸ø Çϰڴµ¥ ¸ÂÀ» °Å¿¹¿ä ¸¸¾à row_number Áö¿ø ¸øÇÏ´Â °æ¿ì¿£ Á»´õ º¹ÀâÇÑ ¹æ¹ýÀÌ ÀÖ±ä ÇÕ´Ï´Ù |
0
0
ÀÛÀº¾ß¼ö
mysql Àε¥ row_number¸¦ Áö¿ø¾ÈÇϳ׿ä.
http://blackbull.tistory.com/43 Âü°íÇؼ ½Ãµµ Çغ¸´Â ÁßÀÔ´Ï´Ù. |
0
0
ÀÛÀº¾ß¼ö
¿Í... ³Ê¹« º¹ÀâÇϳ׿ä..
½ÇÁ¦·Î Àû¿ëÇÒ Äõ¸®´Â ´õ ±äµ¥...¹ÌÄ¡°Ú³×.. |
0
0
Èæ°õÇҾƹöÁö
rank()¸¸ Áö¿øµÇ¾ú¾îµµ.... ¤Ð
|
0
0
ÀÛÀº¾ß¼ö
´ë¹Ú...¾ÏÆ° ¼º°øÇϱäÇ߳׿ä..°¨»çÇÕ´Ï´Ù...
º¹¸¹ÀÌ ¹ÞÀ¸¼¼¿ä~ ÀÌ·¸°Ô ±æ¾îÁú ÁÙÀ̾ß....Àڸ鼵µ »ý°¢¸øÇ߳׿ä ÀÏ´Ü ÀÌ´ë·Î ½á¾ß°Ú³×¿ä.. ¼º´É Æ©´×Àº ¾öµÎµµ ¾È³²¤»¤» SELECT C.* FROM ( SELECT A.*, (CASE @nursery_num WHEN A.n_num THEN @rownum:=@rownum+1 ELSE @rownum:=1 END) AS rnum, (@nursery_num:=A.n_num) AS nursery_num FROM (SELECT nursery_item.num AS n_num, nursery_item.type, nursery_item.title AS n_title, nursery_item.tel , post_img.img , post.num, post.title, post.content, post.emo, post.s_cnt, post.h_cnt, post.e_cnt, post.r_cnt, post.reg_id, post.reg_date , my_nursery.c_name, user.nick, user.p_img FROM post JOIN nursery_item ON nursery_item.num = post.t_num JOIN ( SELECT post_img.* FROM post_img WHERE post_img.type = \'Æ÷½ºÆ®\' GROUP BY post_img.t_num ORDER BY post_img.num ASC )AS post_img ON post_img.t_num = post.num JOIN user ON user.id = post.reg_id JOIN my_nursery ON my_nursery.reg_id = user.id WHERE post.status != \'del\' AND user.status != \'del\' AND my_nursery.status != \'del\' ORDER BY post.reg_date DESC) AS A , (SELECT @nursery_num:=\'\', @rownum:=0 FROM DUAL) B ) C WHERE C.rnum <=2 |
0
0
doctorgu
ÀÌÁ¦¾ß ´ñ±ÛÀ» ºÃ³×¿ä. mySQLÀº ÇÁ·Î½ÃÀú°¡ ¾Æ´Ï´õ¶óµµ º¯¼ö¸¦ ¾µ ¼ö ÀÖ´Ù´Ï ½Å±âÇϳ׿ä.
ÀÌ¹Ì ¹®Á¦¸¦ ÇØ°áÇϼÌÁö¸¸ Á¦ ´äº¯µµ Âü°íÇ϶ó°í Àû¾îµå¸³´Ï´Ù. ÀÏ´Ü ¼ø¼¿¡ °ü°è ¾øÀÌ 2°³¾¿¸¸ °¡Á®¿À·Á¸é ´ÙÀ½°ú °°ÀÌ min, max¸¦ ¾²¸é °£´ÜÇØÁý´Ï´Ù. select Ä«Å×°í¸®, min(Á¦¸ñ) as Á¦¸ñ from #Å×À̺í group by Ä«Å×°í¸® union all select Ä«Å×°í¸®, max(Á¦¸ñ) as Á¦¸ñ from #Å×À̺í group by Ä«Å×°í¸® order by Ä«Å×°í¸®, Á¦¸ñ ±×·±µ¥ ¼ø¼´ë·Î 2°³¸¦ °¡Á®¿À·Á¸é ´ÙÀ½°ú °°ÀÌ minÀ¸·Î Çϳª¸¦ °¡Á®¿À°í, ±× ´ÙÀ½¿¡ ±×°ÍÀ» »« °Í Áß minÀ¸·Î Çϳª¸¦ ´õ °¡Á®¿É´Ï´Ù. ¾Æ¹«·¡µµ ¼º´ÉÀº ´ÔÀÌ ÀÛ¼ºÇÑ°Ô ´õ ÁÁÀ» °Í °°±º¿ä. select Ä«Å×°í¸®, min(Á¦¸ñ) as Á¦¸ñ from #Å×À̺í group by Ä«Å×°í¸® union all select a.Ä«Å×°í¸®, min(b.Á¦¸ñ) as Á¦¸ñ from (select Ä«Å×°í¸®, min(Á¦¸ñ) as Á¦¸ñ from #Å×À̺í group by Ä«Å×°í¸® ) as a inner join #Å×À̺í as b on a.Ä«Å×°í¸® = b.Ä«Å×°í¸® and a.Á¦¸ñ < b.Á¦¸ñ group by a.Ä«Å×°í¸®, a.Á¦¸ñ order by Ä«Å×°í¸®, Á¦¸ñ |
0
0
ÀÛÀº¾ß¼ö
¸Õ°¡ ´õ °£´ÜÇØ º¸À̴µ¥...
ÀÏ´Ü ÀÛ¾÷Àº ¸¶¹«¸®ÇÏ°í À̰ɷεµ ½Ãµµ ÇغÁ¾ß°Ú³×¿ä. min, max¸¦ ÀÌ¿ëÇÑ ¹æ¹ýÀ̶ó sql Äõ¸® ÀÛ¼º ÀßÇϽôºРº¸¸é Á¸°æ½º·´½À´Ï´Ù..¤¾¤¾ |
|
|
¡â ÀÌÀü±Û¡ä ´ÙÀ½±Û | ¸ñ·Ïº¸±â |
±×·ì ¹ÙÀÌÇÑ°Å Ä÷³ ¼¿·ºÆ®¿¡ Àû¾îº¸¼¼¿ä.