小小工程師

/^[a-zA-ZüöäÜÖÄß]+$/ =>英文大小寫+德文 /^\d+$/;   => 正則化檢查數字 /^\w+((-\w+)|(\.\w+))*\@[A-Za-z0-9]+((\.|-)[A-Za-z0-9]+)*\.[A-Za-z]+$/; =>正則化檢查Email /^[A-Z0-9]+$/; =>正則化檢查Email /^[A-Z\sa-z,-]+$/; =>正則化僅輸入英文字及[,-]

SELECT m . Score      , Rank FROM Scores m JOIN ( SELECT Score AS 'Score'            , ROW_NUMBER () OVER ( ORDER BY Score DESC ) AS RANK         FROM ( SELECT DISTINCT Score                  from Scores ) r ) r1   ON m . Score = r1 . Score ORDER BY r1 . Rank Runtime :  1348 ms , faster than  26.61%  of MS SQL Server online submissions for Rank Scores. ------------------------------------------------------------------------ 似乎不好，但簡單的寫法，歡迎大家流言討論，讓你我更好。