G Guest May 21, 2005 #1 Any one know how to delete the first or the second record using SQL statement. Thx, wyghf
E Earl May 21, 2005 #2 "First or second" based on what criteria?? Pass in whatever criteria you want and execute the delete. DELETE FROM Job WHERE ID = YourSelectedID
"First or second" based on what criteria?? Pass in whatever criteria you want and execute the delete. DELETE FROM Job WHERE ID = YourSelectedID
G Guest May 22, 2005 #3 I have A and B table in sqlce database,A is master,B is detail. The customer require when the record count in A is greater than 20,we must delete the first record and append new record,just like a queue.How to achieve it? Thx, wyghf
I have A and B table in sqlce database,A is master,B is detail. The customer require when the record count in A is greater than 20,we must delete the first record and append new record,just like a queue.How to achieve it? Thx, wyghf
G Guest May 22, 2005 #4 Thanks.I've solved this problem Earl said: "First or second" based on what criteria?? Pass in whatever criteria you want and execute the delete. DELETE FROM Job WHERE ID = YourSelectedID Click to expand...
Thanks.I've solved this problem Earl said: "First or second" based on what criteria?? Pass in whatever criteria you want and execute the delete. DELETE FROM Job WHERE ID = YourSelectedID Click to expand...
