• Home
• 2010

Archive for May 2010 - Page 1

1. Select second largest value in a column using SQL

   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 Why LIMIT 1,1 ? Shouldnt it be 2,1 Think again. LIMIT 0,1 is the first record. read on

   
   

2. Select random rows from a table in MySQL

   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

   
   

3. Google search goes social with Social Search Results - The Facebook effect ?

   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 Results ... read on

   
   

4. Perl Script to check Google pagerank

   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 ... read on

   
   

5. Change or Increase font size on Eclipse IDE

   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