Round robin select query - 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

SQL Server 2005 Forums

Transact-SQL (2005)

Round robin select query

Author

Topic

Rafiq-rafiq
Starting Member

2 Posts

Posted - 2013-04-12 : 05:57:35

Hi friends ,
I have a table dbo.test
with columns sno and name
SNO NAME
1 A
2 B
3 C
4 D

when i refresh the page or press f5 in sql server the last record should come first like below
when page is refreshed
SNO NAME
4 D
1 A
2 B
3 C

again when f5 is pressed then
when page is refreshed
SNO NAME
3 C
4 D
1 A
2 B

again when f5 is pressed then
SNO NAME
2 B
3 C
4 D
1 A
again when f5 is pressed then
1 A
2 B
3 C
4 D

i tried my best but not geting any solution yet..could u help me out in this ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-12 : 07:14:51

when i refresh the page or press f5 in sql server..

which page? do you mean ssms query window?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Rafiq-rafiq
Starting Member

2 Posts

Posted - 2013-04-12 : 09:22:19

when i press f5 in sql server to run the query .i should get the data in round robin logic way..

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2013-04-12 : 11:03:02

Do you need this for any application? If yes, why don't you handle it on front end?

Cheers
MIK

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-04-12 : 14:23:18

it should done at front end by means of parameter.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources