Data Set: col1,col2,col3,col4.col5 (A,b,c,d,e) (A,z,p,q,r) (F,s,t,y,v) (F,w,x,y,z) (F,p,x,r,t) (G,m,n,o,p) (G,m,i,q,s)
Actually I need result set that has all the columns and only single row for each capital letter values among the all same capital letter values.
Result set should be like: (A,b,c,d,e) (F,p,q,r,t) (G,k,i,q,s) or (A,z,p,q,r) (F,w,x,y,z) (G,m,n,o,p)
any of three rows.
Actually I have detail records of so many companies in which some where company name are redundant and I have to select single records for each company on the basis of their name. Here I use Capital letters for company name.
I hope you realize the question well.
Please provide a select statement I will be thankful to you all.