I want to get all the values within a distinct value

[table]
[tr]
[td]username[/td][td]password[/td][td]gender[/td][td]age[/td][td]country[/td]

[/tr]
[/table]

$sql = "SELECT DISTINCT username FROM table LIMIT 10";

When I run this query, it select only the username without select the user's password, gender, age, and country. How can I make it select all the values within the username DISTINCT

You can use the sql below.

SELECT DISTINCT
TOP (10)
UserName, Pasword, Gender, Age, Country
FROM TAbleName

manutayo:

You can use the sql below.

SELECT DISTINCT
TOP (10)
UserName, Pasword, Gender, Age, Country
FROM TAbleName

Thanks for your reply. I tried the sql query but it doesn't work. Any other suggestion? Thank you

ok, give me the name of the table you are trying to querry, also are u sure you have those colunm in the table?

use distinct on the username, and pull other columns.

manutayo:

ok, give me the name of the table you are trying to querry, also are u sure you have those colunm in the table?

Thank you. The table name is
States
colums are

state_population, state_weather, major_income, historical_value.

I used DISTINCT state_population, how can I pull other inform that is associated with each population

sayhi2ay:

use distinct on the username, and pull other columns.

Can you use an example. Please include both the sql query. Thank you.

select distinct state_population, state_weather, income from etc etc.


distinct will apply only to the state_population column