>Hi to all,
>
>I wanted to display a list of TOP 10 records base on a given criteria using SQL command, but I'm not sure with the syntax.
>
>Thanks.

Select Top 10 * From mytable ;
  Where < my conditions > ;
  Order By < top 10 column(s) >