projection - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

projection

Author

Topic

Zajcica
Starting Member

22 Posts

Posted - 2013-05-23 : 10:36:14

Hello!
If we have the next table:

Name Age Weight
x 33 45
c 22 40
b 25 41
n 41 43
g 22 40

in this case persons c and g have the same atributes.
Projection eliminates double result and gives next relation:

Age Weight
33 45
22 40
25 41
41 43

so, the double one is eliminated.

My question is: what is the point of that? Main reason for that?
How does it serve in practic examles we meet in life?

Many thanks!

Many thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-05-23 : 11:22:41

https://forums.oracle.com/forums/thread.jspa?threadID=2309172

Dinesh.sharma2
Starting Member

2 Posts

Posted - 2013-05-24 : 05:08:35

Use Distinct Clause.

select distinct age,weight from table

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources