Query Modification for Top 8 - 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

Query Modification for Top 8

Author

Topic

dhinasql
Posting Yak Master

195 Posts

Posted - 2009-01-29 : 07:20:21

Dear Friends,

I have the query, that are fetching all the valuse, But i want to display only top 8 records, when i use top 8 i am getting 10 results, Please modify the query and help me to get the top 8 output

The Query is :

SELECT wlbuserfls.email,wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate,wlbBuddies.userid FROM wlbuserfls INNER JOIN wlbBuddies ON wlbuserfls.userid = wlbBuddies.userid where wlbBuddies.buddyid=51151
Union SELECT wlbuserfls.email, wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate, wlbBuddies.buddyid as userid FROM wlbuserfls INNER JOIN wlbBuddies ON wlbuserfls.userid = wlbBuddies.buddyid where wlbBuddies.userid=51151
UNION SELECT wlbuserfls.email, wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate,wlbuserfls.userid as userid from wlbuserfls where userid=51151

Please help me to get the TOP 8 Results,

Thanks in Advance

raky
Aged Yak Warrior

767 Posts

Posted - 2009-01-29 : 07:23:46

try this

SELECT
top 8 a.*
from
( select
wlbuserfls.email,wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate,wlbBuddies.userid
FROM wlbuserfls
INNER JOIN wlbBuddies ON wlbuserfls.userid = wlbBuddies.userid where wlbBuddies.buddyid=51151
Union SELECT wlbuserfls.email, wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate, wlbBuddies.buddyid as userid FROM wlbuserfls INNER JOIN wlbBuddies ON wlbuserfls.userid = wlbBuddies.buddyid where wlbBuddies.userid=51151
UNION SELECT wlbuserfls.email, wlbuserfls.firstname, wlbuserfls.lastname, wlbuserfls.country, wlbuserfls.zip, wlbuserfls.gender, wlbuserfls.goal, wlbuserfls.joiningdate, wlbuserfls.picture, wlbuserfls.lastlogindate,wlbuserfls.userid as userid from wlbuserfls where userid=51151 ) a

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-29 : 09:06:38

you need top 8 based on what order? you should specify the order by means of an order by clause. raky's code will give just 8 random records which may not necessarily be in any sequence.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources