This does not guarantee the first row.How about this?select min(col1) from t1
select col1 from t1 where rownum=1
Results 1 to 10 of 15
Thread: concatenate all rowsThreaded View
|
Click Here to Expand Forum to Full Width |