var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am using the append query to populate data into an empty table. I only need the top 20 records based on my sales field. How can I limit my table to only 20 records. Will I do this through the query, table design, or through code? Thanks
Your question already contains the keyword, "top"
INSERT INTO MyTable (MyInsertFieldList)
SELECT TOP 20 MySelectFieldList
ORDER BY sales DESC;
...inserts from the records with the 20 highest sales values.
Like a charm....Thanks, Dude
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors