SQL Query: Get total records for a table.

Hi
It's bit unclear if you want just the total amount of records - 1 (which would be simply COUNT(*) - 1) or if you want to have the data from all records except one.

Let's say you need the records then you have to decide the correct condition for the WHERE clause. For example if you don't want to include the last row added and you have an IDENTITY field called ID in the table then the select could be something like:

SELECT *
FROM MyTable
WHERE Id < (SELECT MAX(Id)
            FROM MyTable)

If you want the total records in a table do:

select Count(*)as Total from [tablename]

If you want Total -1 do:

select Count(*)-1 as Total from [tablename]

If you want the total of records for a set criteria do:

select Count(*) as Total from [tablename] where [Field]=0 --whatever your condition may be

so in this case I am counting all records in the table having my field with a value of 0

Hope this solves your problem