Please explain in detail with query.
Loading
Please explain in detail with query.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sachin SinghPosted Aug 5, 2022, 5:08 PM
Sachin SinghPosted Aug 5, 2022, 5:35 PM
Aryan KumarPosted Aug 5, 2022, 5:28 PM
Thanks you so much Sachin. but please update your answer...like below.....
delete from [dbo].[Products] where
ID in (
select ID from (
select Id,Row_number() over (order by ID) RN from [Products]
)
[Products] where RN <=1000
)
Highlighted part (Table Name) is missing in both query. I will accept it once updated ,Thanks