Query Help Sql

[lolliman]

ledanteee [b]sub Query[/b] use cheyyalnukuntaaa???

[ChampakDas]

karma confirm chesi povayya ante....confirm cheskodaniki motham table create chesi mari dhobichukovalsivastundi...its working enjoy

Create table ABC
(Property varchar(max),
room varchar(max),
rank int)

ABC TYY 1
ABC TYx 3
ABC HDD 5

Query:
DECLARE @RANK INT,@PROPERTY VARCHAR(MAX)
SELECT @RANK=1, @PROPERTY = 'ABC'
SELECT TOP(1) Property, Rank FROM ABC where RANK <> @Rank and Property = @property
group by Property, RANK order by rank

Output:
ABC 3

[deals2buy]

[quote name='ChampakDas' timestamp='1351020774' post='1302677827']
karma confirm chesi povayya ante....confirm cheskodaniki motham table create chesi mari dhobichukovalsivastundi...its working enjoy

Create table ABC
(Property varchar(max),
room varchar(max),
rank int)

ABC TYY 1
ABC TYx 3
ABC HDD 5

Query:
DECLARE @RANK INT,@PROPERTY VARCHAR(MAX)
SELECT @RANK=1, @PROPERTY = 'ABC'
SELECT TOP(1) Property, Rank FROM ABC where RANK <> @Rank and Property = @property
group by Property, RANK order by rank

Output:
ABC 3
[/quote]

deeni kosame chustunnattundu indaaka nundi [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] anyways

[ChampakDas]

[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[quote name='deals2buy' timestamp='1351020824' post='1302677834']
deeni kosame chustunnattundu indaaka nundi [img]http://i56.tinypic.com/2w2r5gm.jpg[/img] anyways
[/quote]

[lolliman]

[quote name='ChampakDas' timestamp='1351020774' post='1302677827']
karma confirm chesi povayya ante....confirm cheskodaniki motham table create chesi mari dhobichukovalsivastundi...its working enjoy

Create table ABC
(Property varchar(max),
room varchar(max),
rank int)

ABC TYY 1
ABC TYx 3
ABC HDD 5

Query:
DECLARE @RANK INT,@PROPERTY VARCHAR(MAX)
SELECT @RANK=1, @PROPERTY = 'ABC'
SELECT TOP(1) Property, Rank FROM ABC where RANK <> @Rank and Property = @property
group by Property, RANK order by rank

Output:
ABC 3
[/quote]


[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[Cherry25]

[quote name='ChampakDas' timestamp='1351020774' post='1302677827']
karma confirm chesi povayya ante....confirm cheskodaniki motham table create chesi mari dhobichukovalsivastundi...its working enjoy

Create table ABC
(Property varchar(max),
room varchar(max),
rank int)

ABC TYY 1
ABC TYx 3
ABC HDD 5

Query:
DECLARE @RANK INT,@PROPERTY VARCHAR(MAX)
SELECT @RANK=1, @PROPERTY = 'ABC'
SELECT TOP(1) Property, Rank FROM ABC where RANK <> @Rank and Property = @property
group by Property, RANK order by rank

Output:
ABC 3
[/quote]

Multiple 3s unte???

[Cherry25]

Thanks champak...approach ayyanu

[ChampakDas]

you mean some 100 records for same property? If so even then it works
[quote name='Cherry25' timestamp='1351021950' post='1302677993']
Multiple 3s unte???
[/quote]

lyt...approach ayanu endhi?
[quote name='Cherry25' timestamp='1351021988' post='1302677996']
Thanks champak...approach ayyanu
[/quote]

[deals2buy]

[quote name='ChampakDas' timestamp='1351022158' post='1302678025']

lyt...approach ayanu endhi?
[/quote]
[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]

[ChampakDas]

endhi mama approach golla you got ?[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[quote name='deals2buy' timestamp='1351024416' post='1302678373']
[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]

[deals2buy]

[quote name='ChampakDas' timestamp='1351026739' post='1302678665']
endhi mama approach golla you got ?[img]http://i56.tinypic.com/2w2r5gm.jpg[/img]
[/quote]
please approach lollilolli2012 [img]http://i56.tinypic.com/2w2r5gm.jpg[/img]