Delete all rows except 10 random rows
1001096Apr 5 2013 — edited Apr 5 2013Hi,
how can I delete all rows from table JOBS except 10 random rows?
Someone asked it before (not here..): http://stackoverflow.com/questions/10820105/t-sql-delete-except-top-1
but I didn't understand the answer, and I don't think it will work in PL/SQL.
If the answer in StackOverflow does works in PL/SQL, I will glad if someone explains me with better example,
If the answer in StackOverflow does'nt work in PL/SQL, I will glad if someone gives me an example.
thanks!