Member Avatar for virusisfound

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

  • 2 Contributors
  • 1 Reply
  • 133 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by VIeditorlover
Member Avatar for VIeditorlover 
select distinct name, count(*) over (PARTITION by name)*100.0 / COUNT(*) over () x
from peoplenames
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.