Select distinc records from a table column but display all columns

[JERRYLEGUER]

I want to create a view that has distinc records of one of the five columns of the view i want to create. The view only takes data from one table.

[jeenajos]

I want to create a view that has distinc records of one of the five columns of the view i want to create. The view only takes data from one table.

Hi
R u trying to say that u want to create a view with distinct values from a table?
Then try this:
Create View viewname as select distinct * from tablename

Thanks jeen