select distinct from dataset

Question

I have got duplicate rows in a dataset. how can i select distinct rows from that.

From comments: My query is something like this:

select name, age 
from student

When I receive its output in a dataset the output consists of rows having duplicate names. Using dataset itself I have to select distinct name from this because I need the same query with duplicate values for some other place.

Answer 1

 select DISTINCT name, age from student

Answer 2

If you need both the distinct data as well as the full data (with duplicate values), then you'll either have to maintain two datasets or continue doing things as you are now.