List Non Duplicate Data in a table

by Vinoth 2008-09-23 14:43:28

Hi,
If you need to display only non Duplicate datas in a table. That can be done by using the key word DISTINCT
e.g;
>SELECT DISTINCT FIELD_NAME FROM TB_NAME;

Similarly for get average of a particular field
>SELECT AVG(FIELD_NAME) FROM TB_NAME;

Tagged in:

1348
like
0
dislike
0
mail
flag

You must LOGIN to add comments