DISTINCT QUERY

[patrick]

Hello

Sir, I have a question.

I want to extract data from the original data like below.

I want to extract data(NO,NAME,AGE,Gender,Height,Weight Column)
where AGE:20 AND Gender:Girl

How should I structure my query?
Please teach me.

The DISTINCT function does not work because only the AGE and Gender Columns are Only extracted.

I want to extract only data(NO,NAME,AGE,Gender,Height,Weight Column) where the AGE:20 and the Gender:Girl

 

[jmcilhinney]

As you have described it, the problem has nothing at all to do with distinct records. It's a straight SELECT statement with a WHERE clause. I'm not sure what the actual issue is.

 

[Skydiver]

I think that the OP wants us to write the SQL for them.