å¯ä»¥ä½¿ç¨å ç½®å½æ° dense_rank() over () çæ¹å¼æ¥è¿è¡åç»æåºç¼å·ï¼å°±æ¯è¯´æç §ä½ çæåºæ¹å¼æ¥èªå¨çæåºåç¼å·è¿½é®
è½ä¸¾ä¾ä¹
追ç
æ¯å¦ï¼ select dense_rank() over (order by aa) as xh, bb,cc from table è¿ä¸ªæ ·ååï¼order by è¦åå¨overéé¢ï¼byåé¢çå段就æ¯ä½ è¦åç»ç¼å·çå段äºã