HOW to delete the same data in the table？

[#1]

dear，

 every time i go to menu which “row” to detele  the same data ，

i  want to delete the same data in  the table automaticly， and  i don t know to how  to write JSL  

how i do to write ？

[#2]

Made slight mistake - using Min will return your "delete" table.

[#3]

I went ahead and redid it by putting subquery as table so you can see difference. Sometimes one way works better or is clearer than the other. Here the "t1" and "t2" are aliases.

SELECT t1.*

FROM Solubility t1,

( SELECT DISTINCT "LOT NO", Min("Column 1") AS "Column 1" FROM Solubility GROUP BY "LOT NO" ) AS t2

WHERE t1."Column 1" = t2."Column 1"

;

[#4]

i am sorry to tell you that it can not work

the alarm is circular reference;

SELECT t1.*
FROM [Solubility$] t1,
( SELECT DISTINCT "LOT NO", Min("Column 1") as "Column 1" FROM [Solubility$] GROUP BY "LOT NO" ) AS t2
WHERE t1."Column 1" = t2."Column 1"

[#5]

I just started from scratch and it worked on my end. Tried both MIn() and Max() and it gave what I was expecting.

I did notice a couple of things:

1. When I told you I added column 1, I forgot to mentioned I initialized it to sequential numeric. IE I basically replicated the row number.

2. Noticed you use the brackets around the table name, and the table name ends in "$". Those are MS take on SQL. Try eliminating those.

3. Can't remember if I told you to hit the update button in the custom sql window or not, but seems to help me before I run query.