Any one know how to delete the first or the second record using SQL statement.


Thx,
wyghf

"First or second" based on what criteria?? Pass in whatever criteria you
want and execute the delete.

DELETE FROM Job WHERE ID = YourSelectedID

"wyghf" <(E-Mail Removed)> wrote in message
news:947A1C7B-771F-4F8C-A75C-(E-Mail Removed)...
> Any one know how to delete the first or the second record using SQL
> statement.
>
>
> 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

"Earl" wrote:

> "First or second" based on what criteria?? Pass in whatever criteria you
> want and execute the delete.
>
> DELETE FROM Job WHERE ID = YourSelectedID
>
> "wyghf" <(E-Mail Removed)> wrote in message
> news:947A1C7B-771F-4F8C-A75C-(E-Mail Removed)...
> > Any one know how to delete the first or the second record using SQL
> > statement.
> >
> >
> > Thx,
> > wyghf
>
>
>

Thanks.I've solved this problem

"Earl" wrote:

> "First or second" based on what criteria?? Pass in whatever criteria you
> want and execute the delete.
>
> DELETE FROM Job WHERE ID = YourSelectedID
>
> "wyghf" <(E-Mail Removed)> wrote in message
> news:947A1C7B-771F-4F8C-A75C-(E-Mail Removed)...
> > Any one know how to delete the first or the second record using SQL
> > statement.
> >
> >
> > Thx,
> > wyghf
>
>
>