The answer is pretty simple without jumping over hoops or thinking about taking MAX etc.
SELECT value FROM table ORDER BY value DESC LIMIT 1,1
In order to select a random row from MySQL, we can order the rows by a random number and then pick the first row.
SELECT * FROM node ORDER BY rand() limit 1;
The above query randomly selects a row from the table node.read on
The following is the screenshot of Google Search result page when searched for something my friend has blogged on.
Is google moving towards a social networking side ?
Google is slowly adding the "Social" aspect to all its products. After launching Buzz on Gmail, "Social …read on
In order to find out a Google Pagerank of a webpage, we can use the WWW::Google::PageRank module in Perl.
Click WWW::Google::PageRank to download the Google Pagerank module. Here is a simple script that takes the Website URL as a command line argument and prints the …read on
I have a Sony Vaio CW Series laptop, and it supports a high resolution of 1600 x 900 pixels in a small 14 inch screen. The pros of this resolution is to have more screen space for editors or IDEs such as Eclipse. The bad …read on