Re: query to delete last record of a table

From: <cricketunes_at_yahoo.com>
Date: 17 Apr 2005 22:09:36 -0700
Message-ID: <1113800976.128913.171420@f14g2000cwb.googlegroups.com>

Awrite my bad. I shud have explained better.

I have this attribute Customer ID as a Primary Key and it goes sequentially like C1, C2, C3.....

I want a query like this:
Delete from Customer where CustID = 'C'+'select count(*) from Customer';

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

What is the correct expression for the underlined part of the query string?

Thanks :) Received on Mon Apr 18 2005 - 00:09:36 CDT