SQL SERVER||Select and delete First 'n' Last records when there is no Primary Key
ฝัง
- เผยแพร่เมื่อ 3 ธ.ค. 2024
- WITH CTE AS(
select *,ROW_NUMBER() OVER(ORDER BY (SELECT NULL))AS rn From customer)
select * from cte where rn between 6 and 10
WITH CTE AS(
select TOP (2)* From customer)
Select * FROM CTE