Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using timestamp?
Hi.. I would like to have a select statement from my table that makes sure the info I am after is caught for at least 5 minutes after the info is added. WHY: People on my site can send a message that will put their image on my main page. I have limited the query to show only 5 images. I now... -
Retrieving top 100 results
I guess this would be a disaster for performance? -
Retrieving top 100 results
Thanks. Man.. But I am on version 3.23.58 Is there no way then? -
Retrieving top 100 results
Hi. I am trying to get an average value from my database but I only want to retrieve the average out of the top 100 results. The column I want to average contains values from 0.1 to 10.0. So I want to get the average from the top 100 values in this column. The average syntax is clear but what...
