Sql Doubt

[sqlhelp]

Hi, 

 

 naku unique values kavali from a row other than distinct method  can we use any other method ? 

 

select -1, u.ID, -1, g.ID, g.Name

from vwUsers u 

join vwGroups g on g.Name = 'abc' 

join vwOrders o on o.ShipToID = u.LinkID and o.ProductID = 123

 

u.ID duplicate values vasthunayi

[dotnetrockz]

whats this -1?

 

r u talking abt MS SQL SERVER?

[JollyBoy]

distinct enduku use cheyakuda..

[sqlhelp]

whats this -1?

 

r u talking abt MS SQL SERVER?

yes ms sql server 

 

-1 just to differentiate columns 

[macha]

you need to build something like this 

 

select -1, u.ID, -1, g.ID, g.Name

from vwUsers u 

where exists(select * from  vwGroups g on g.Name = 'abc') 

 

 

here are some examples 

http://www.techonthenet.com/sql/exists.php

[JollyBoy]

 

you need to build something like this 

 

select -1, u.ID, -1, g.ID, g.Name

from vwUsers u 

where exists(select * from  vwGroups g on g.Name = 'abc') 

 

 

here are some examples 

http://www.techonthenet.com/sql/exists.php

 

naku aa q and nee A rendu ardam kale..

[sqlhelp]

 

you need to build something like this 

 

select -1, u.ID, -1, g.ID, g.Name

from vwUsers u 

where exists(select * from  vwGroups g on g.Name = 'abc') 

 

 

here are some examples 

http://www.techonthenet.com/sql/exists.php

 

adi enti join ela cheshtam apudu ? 

[sqlhelp]

group by use cheyacha? 

[Hyderabad_Nawab]

naku aa q and nee A rendu ardam kale..

aa Element Attributes e Confusinga Unnayi....:P

 

Just Em cheyyalo (Main Prob.) Clarity ga chepthe..dhaaniki Solution Iccheste better...

[JollyBoy]

bhayyo.. naku clarity missing.. ardamayela chepte try chesta

[vikuba]

 

group by use cheyacha? 

 

yes group by cheyi...

u will get the distinct

[JollyBoy]

WITH cte AS (

 

 

select -1, u.ID, -1, g.ID, g.Name, RANK() OVER
    (PARTITION BYu.ID ORDER BYu.ID) AS Rank
 

from vwUsers u 

join vwGroups g on g.Name = 'abc' 

join vwOrders o on o.ShipToID = u.LinkID and o.ProductID = 123

 

) SELECT * FROM CTE WHERE RANK = 1

[JollyBoy]

try the above vuncle

[Pandu_age40]

WITH cte AS (


select -1, u.ID, -1, g.ID, g.Name, RANK() OVER
(PARTITION BYu.ID ORDER BYu.ID) AS Rank

from vwUsers u
join vwGroups g on g.Name = 'abc'
join vwOrders o on o.ShipToID = u.LinkID and o.ProductID = 123

) SELECT * FROM CTE WHERE RANK = 1

Agree

[sqlhelp]

WITH cte AS (

 

 

select -1, u.ID, -1, g.ID, g.Name, RANK() OVER
    (PARTITION BYu.ID ORDER BYu.ID) AS Rank
 

from vwUsers u 

join vwGroups g on g.Name = 'abc' 

join vwOrders o on o.ShipToID = u.LinkID and o.ProductID = 123

 

) SELECT * FROM CTE WHERE RANK = 1

 

the column id was specified multiple times for cte  ani vasthundi