>Hello Fellow Developers
> I have a question about a select statement that I am creating. I am trying to grab the top 10 records that meat a certian type of criteria in a database. I know about the cnt command but every time I use this I get a single record with my table count. I was wondering if this was possible to do in a select statement or if I have to select disting and the scan through and count ?
>
>Please help with suggestions
>
>Darren In Atlanta
Select Top 10 * From MyTable Order by MyField
Edward Pikman
Independent Consultant