StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>DON'T LOOP!</strong></p> <p>I prefer marking th rows with a status, but this will do as you want and delete them...</p> <p>try this (sql server)</p> <p>set up table</p> <pre><code>create table tREaltyTrac (city varchar(20),creation datetime) insert into tREaltyTrac values ('Acampo' ,getdate()) --1 waitfor delay '00:00:01' insert into tREaltyTrac values ('Acton' ,getdate()) --1 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Adelanto' ,getdate()) --20 waitfor delay '00:00:01' insert into tREaltyTrac values ('Agua Dulce' ,getdate()) --1 waitfor delay '00:00:01' insert into tREaltyTrac values ('Aguanga' ,getdate()) --1 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Akron' ,getdate()) --19 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albany' ,getdate()) --12 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albion' ,getdate()) --3 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albion' ,getdate()) --3 waitfor delay '00:00:01' insert into tREaltyTrac values ('Albion' ,getdate()) --3 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alexandria' ,getdate()) --14 waitfor delay '00:00:01' insert into tREaltyTrac values ('Algonac' ,getdate()) --1 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alhambra' ,getdate()) --5 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alhambra' ,getdate()) --5 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alhambra' ,getdate()) --5 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alhambra' ,getdate()) --5 waitfor delay '00:00:01' insert into tREaltyTrac values ('Alhambra' ,getdate()) --5 </code></pre> <p>display table values</p> <pre><code>select city,count(*) from tREaltyTrac group by city select * from tREaltyTrac </code></pre> <p>delete the rows you don't want</p> <pre><code>delete from tREaltyTrac from tREaltyTrac inner join (select city,creation, row_number() over(partition by city order by city) AS RankValue from tREaltyTrac ) dt on tREaltyTrac.city=dt.city AND tREaltyTrac.creation=dt.creation where dt. RankValue>10 </code></pre> <p>show the rows you have left</p> <pre><code>select * from tREaltyTrac select city,count(*) from tREaltyTrac group by city </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload