Hi all,



I am facing one problem in oracle



That is I have a table (test11) it has two columns (no,name), both
columns has to be defined as the varchar2 data type.

The column No having numeric data as well as character data, I want to
fetch the minimum value of NO from that table, for that I have written
the below query but its not returned the correct record



Select min (no), name from test11 group by name



So please suggest me that how can retrieve the minimum value of NO from
that table?



Thanks and Regards,

Siva.P

Bangalore






Oracle LazyDBA home page