Page 1 of 1

What will this query do? DELETE FROM x. Student WHERE rowid not in (SELECT MIN(rowid) FROM x.Student GROUP BY Student Fi

Posted: Thu May 05, 2022 1:00 pm
by answerhappygod
What Will This Query Do Delete From X Student Where Rowid Not In Select Min Rowid From X Student Group By Student Fi 1
What Will This Query Do Delete From X Student Where Rowid Not In Select Min Rowid From X Student Group By Student Fi 1 (5.73 KiB) Viewed 23 times
What will this query do? DELETE FROM x. Student WHERE rowid not in (SELECT MIN(rowid) FROM x.Student GROUP BY Student FirstName, Student.Id, Student.lastName);