>hi all
>
>how can i get in one statment all the fileds from a table where min(field1)
>
>thanx

Try

 SELECT * FROM mytable ;
  WHERE field1 IN ( SELECT MIN(field1) FROM mytable)