Dusan Kolesar wrote: > > Hello, > > Thank you very much for your previous advices. > I have next 2 questions: > > 1. I want to limit SELECT result. For example I want get only > row (all > collumns) with Minimal value of some field (column). How can > I get this > result? In My SQL I can do it by: > SELECT * FROM tb ORDER BY col ACS LIMIT 1
select * from tb where acs = (select min(acs) from tb) where rowno <=1 An index for acs would increase performace in that case (if acs is not the first keycolumn). Elke SAP Labs Berlin > > Best regards, > Dusan > > -- > Dusan Kolesar > Helsinska 19 > 040 13 Kosice > Slovakia > e-mail: [EMAIL PROTECTED] > ICQ#:160507472 > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
