to retrive 50% of data from table

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 2000 Forums

SQL Server Development (2000)

to retrive 50% of data from table

Author

Topic

kodali
Starting Member

2 Posts

Posted - 2007-08-27 : 06:56:44

can any body help me to retrive the data 50% from the table. If it is possible can you please send me the query

thanks & regards

kumar

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-27 : 07:05:04

select top 50 percent * from table1
order by <some criteria here>

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-27 : 07:23:24

You also need to search for Pagination

Madhivanan

Failing to plan is Planning to fail

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-27 : 07:25:03

Or "Where do you want to retreive the other 50% from?"

E 12°55'05.25"
N 56°04'39.16"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-27 : 07:27:56

quote:
Originally posted by Peso

Or "Where do you want to retreive the other 50% from?"

E 12°55'05.25"
N 56°04'39.16"

Classic

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources