Listing top 60 cars that are InStock.

  • Thread starter Thread starter Joe M
  • Start date Start date
J

Joe M

SELECT TOP 60 Car.*, Car.Number
FROM Car
ORDER BY Car.Number DESC;

At the moment I've got this query, it works fine listing the top 60 lastest
cars. But now I need a new criteria. I've just added a new field [InStock]
to the table(a yes/no field). I need the query to list only the top 60
titles that has the [InStock] field set to yes. How do I do this?
 
SELECT TOP 60 Car.*, Car.Number
FROM Car
WHERE InStock = True
ORDER BY Car.Number DESC;


FWIW, there's no reason to add the , Car.Number in the query. As you've no
doubt found, one of the two occurrences of Number is going to be labelled
Field1 (or something like that)
 
Back
Top