|
Hey, so I've been 100% inspired by Gagich to make my own list of my favourites this year!
I decided to go for single only, as there'd be one artist in particular that might make it a pretty boring list (>.> 1 guess who)!
25. Jessie J - Who You Are...
Started by VoReason on
, 24 posts
by 15 people.
Answer Snippets (Read the full thread at ukmix):
|
|
Arguably the best show on television.
i dont know how old this episode is, or if yall saw it or not but:
10. randall cunningham
9. jeff george
8. drew bledsoe
7. warren moon
6. jim kelly
5. dan marino
4. steve young
3. troy aikman
2. john elway
1. bret...
Started by Wacky D on
, 15 posts
by 14 people.
Answer Snippets (Read the full thread at projectcovo):
Dude was one of the most accurate passers in his prime and for most of the 90's was a top notch-tasking by the time they hit the ....
He at 2.
Brett Farve.
Dan Marino is number one.
Fucc it, off top i'll say i'd have Harbaugh over him.
|
|
In no particular order
1. Medal of Honour: Allied Assault
2. Need for speed: Underground
3. Championship Manager 03-04
4. Pro Evolution 4
5. Mario Kart (SNES)
6. Half-Life + endless mods
7. Command and Conquer: Tiberian Sun
8. Goldeneye
9. The legend ...
Started by Jester on
, 21 posts
by 19 people.
Answer Snippets (Read the full thread at ffshrine):
Final Fantasy VII
7....
Suikoden
6.
Xenogears
5: shenmue
8: mario kart
9: grandia
10: gta vice city Haha my list is going to chance when I get my.
Suikoden III
4.
Nights Into Dreams
3.
Suikoden II
2.
Legens will leave my top 10 =p 1.
|
Ask your Facebook Friends
|
I want to return top 10 records from each section in the one query. Can anyone help how to do it. Section is one of the column in the table.
Database is sql server 2005. Top 10 by date entered. Sections are business, local and feature For one particular...
Started by jazzrai on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
When you say top 10 are we talking about value or most recently entered?
Might the UNION clarification):
select * from Things t where t.ThingID in ( select top 10 ThingID from Things tt where order by Section, DateEntered....
|
|
Say I've got a query
SELECT TOP 10 ... FROM ... ORDER BY ...
in Access (well, really Jet). The question is: how can I get all the other rows... everything except the top 10?
Started by Joel Spolsky on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
It might not ....
ORDER BY rankfield) ORDER BY sortfield
Note that your sorted FROM ...) ORDER BY .. .
WHERE PK NOT IN (SELECT TOP 10 PK myID NOT IN (SELECT TOP 10 myID FROM ...
FROM ...
Couldn't you do something like
SELECT ...
|
|
I have 100 records in which i can select top 10 using the "TOP 10" in the query. Similarly is there anything to get the 20th to 30th record?
Started by Vinodtiru on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
A lot of records, using TOP X in the inner SELECT clause may speed up things a bit as there is no use FROM (SELECT TOP 20 ROW_NUMBER() OVER (ORDER BY Date DESC) AS Row, Description, Date FROM LOG.
|
|
Imagine I have a table showing the sales of Acme Widgets, and where they were sold. It's fairly easy to produce a report grouping sales by country. It's fairly easy to find the top 10. But what I'd like is to show the top 10, and then have a final row...
Started by arooaroo on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I don't have access to SQL here but I'll hazzard a guess:
select top (10) Ctry, sales from table1 union all select 'other', sum(sales) from table1 left outer join (select top (10) Ctry, sales if this is a rapidly changing....
|
|
Select * from ( select year, week, salesperson, count(*) as transactions, rank() over(partition by week order by count(*) desc) as ranking from sales where year = '2010', group by year, week, salesperson ) temp where ranking <= 10
The query returns...
Answer Snippets (Read the full thread at stackoverflow):
SalesPersonId, Count(*) As Top10Count From SalesByWeek Where SaleRank <= 10 Group By SalesPersonId.
|
|
We did this in 2002/03:
http://www.lemon64.com/forum/viewtopic.php?t=5353
with these results:
http://www.lemon64.com/forum/viewtopic.php?t=11039
Then again in 2007/08:
http://www.lemon64.com/forum/viewtopic.php?t=24170
Does anybody want to give it another...
Answer Snippets (Read the full thread at lemon64):
Mayhem of this list that I still....
Rolling Ronny
2.
Zak McKracken My current top point) Some changes from my previous list , my current top 10 games:
1.
The Last Ninja
10.
Gunship
9.
Bard's Tale III
8.
Katakis
7.
Paradroid
6.
|
|
I have a function on my site where people can vote on photos. Everytime someone click the vote-button my script adds a row in a table (mysql).
Each row looks like this: (Table name = likes)
id userId photoName date
1 21 34234 20100101
How do i find the...
Started by Haljan on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You group in desc order, to get the most liked ; ... .
SELECT COUNT(*) as points, photoName FROM likes GROUP BY photoName ORDER BY points DESC LIMIT 10, count(*) as nbLikes from likes group by photoName order by count(*) desc limit 0, 10
i.e.
|
