I am working in SQL 2005 I want to Create view for one table.

Table Name abc

1. id
2. name
3. percentage
4. marks

How can i create view for one column I want to search the name and makrs and name and % both have searching on name condition. the queary work seprately. but i want to combine the queary and display result in one table.

The result should be like this :

name id name %

How to do this.
please... Please... Please...
Give me solution

select distinct name, count(*) over (PARTITION by name)*100.0 / COUNT(*) over () x
from peoplenames