How can I get the top 15 records entered from a db? Either SQL or ASP, preferrably SQL. THANKS
Try this. "Select * top 15 from tblName". Substitute tblName with the actual name of your table. Add a where and/or order clause to finetune your selection eg "Select * top 15 from Customer where City = 'Kuala Lumpur' order by Country.
I'm using MS Access. I don't think this is allowed. I get a syntax error. 'SELECT * top 15 FROM FCC_RELEASES ORDER BY CREATED_DT'
Hey, it should be<BR><BR>'SELECT top 15 * FROM ......'<BR>instead of <BR>'SELECT * top 15 FROM ......'<BR>ok?<BR><BR>