SELECT * FROM (SELECT * FROM) S7an 12/17/2014 12:00:00 下午 0 Comments SELECT a, b, c, f FROM ( SELECT a, b, sum(c), d, e, f FROM TABLE_A ORDER BY a, b, c, d, e, f )... Read More Read more 沒有留言:
length 與 lengthb 的使用差異 S7an 11/25/2014 09:28:00 上午 0 Comments length >>算字元長度 lengthb >>算字元byte長度 ---------------範例--------------- Column Value = 'IT網誌' SELECT length (Co... Read More Read more 沒有留言: