SELECT TOP 5 * FROM(SELECT TOP 5 * FROM Table ORDER BY Column) as A ORDER BY Column DESC;
SELECT * FROM(SELECT row_number() over(order by Table) as rowid, * FROM Table) A where rowid between 1 and 100;
위의 두가지 select문을 update 문으로 바꾸는 방법좀 부탁드립니다.수고하세요
SELECT문을 UPDATE문으로 바꿀 수...가 있는건가요?
update Table set A_Column='0' SELECT TOP 5 * FROM(SELECT TOP 5 * FROM Table ORDER BY Column) as A ORDER BY Column DESC;
update Table set A_Column='0' SELECT * FROM(SELECT row_number() over(order by Table) as rowid, * FROM Table) A where rowid between 1 and 100;
이런씩으로하니 update가 안되요
넵 우욱님께 정말 감사드립니다....수고하세요
