一般的なsqlコマンド

##         
#       ：
CREATE TABLE
newtablename
as 
SELECT
*
from 
oldtablename

#     ：
SELECT
*
INSERT INTO
newtablename
from 
oldtablename

——————————————————————————————————————————
#      （MediaId）        
CREATE TABLE
tt
as
SELECT
    *
FROM
    image_en_picfeatures
WHERE
    MediaId IN (
        SELECT
            MediaId
        FROM
            image_en_picfeatures
        GROUP BY
            MediaId
        HAVING
            count(MediaId) > 1
    )
	
SELECT * from  tt;


#  mediaId     ，       r(id)	     
DELETE
FROM
    tt
WHERE
    MediaId IN (
        SELECT
            MediaId
        FROM
            tt
        GROUP BY
            MediaId
        HAVING
            count(MediaId) > 1
    )
AND r NOT IN (
    SELECT
        min(r)
    FROM
        tt
    GROUP BY
        MediaId
    HAVING
        count(MediaId) > 1
)

#(3)    update r  No.

##      row_number
select row_number() over(order by MediaId) as row_number,* from tt

##          
    newid   ，not null