Re: How to get TOP 10 by sql ?

Posted in 1998

Carl in Atlanta — 21 Sep 1998 04:11:29 GMT — source: Informix-list mailing list archive (1991-1998)

If you have 7.3 you can tell it how many records you would like. carl '''' wrote in message <6u4998$bgd$1@news.seed.net.tw>... >Hi everybody, > How can I get top 10 by sql? > I know that I can use ' Select * from mytable order by mycol ' > to get all the data ascend or descend. > But , how to get them only the top 10 ? > >thanks !! > >James Chung >Tatung Co. >Taipei Taiwan > >