First of all you must be a little familiar with jQuery. But you are not expected to be a jQuery expert. Secondly, you must also be familiar with javascript and CSS and thirdly, you must be eager to learn🙂.

For quite a few days I was searching for something that gives me the ability to

  1. open a link (outside webpage) in a popup window
  2. Open HTML controls in popup
  3. Can show images in the popup
  4. Can show images as a slideshow in a popup
  5. Can show inline HTML in a popup
  6. Should be sexy, not like the old school HTML popup window

Continue reading ‘Fancy, Sleek and Stylish JQuery Popup With ColorBox’

  1. Download executable jar from here.
  2. Put the downloaded file in C drive or anywhere you like
  3. Open command prompt ( Start > Run > write cmd and press OK)

I had a situation today, I accidentally executed SQL insert script twice. The bad thing was that the table had no primary key or unique key defined which may have stopped it from execution.

Lesson: Not having Primary keys is a bad idea

So, now I can not delete each row manually so I had to write a query which could do that for me. Thanks god it saved me a lot of time.

So here goes the query, rather queries for performing the same functionality.

Continue reading ‘How To Delete Duplicate Rows in Database Table’

Finding highest or lowest number in a column is easy, you can do that with max() and min() SQL function. But I had recently been asked in an interview to write a query that could find the second highest value in a table column.

Ooops, and I didn’t do well in that interview either.LOL

Before showing you the query, first, let me make things more easy for you. Here is the table script for our very simple JOB table.


Done? Lets move on and insert a few records in JOB table.

Insert into JOB   (JOB_ID, DESCRIPTION) Values   (1, ‘Teaching’);
Insert into JOB   (JOB_ID, DESCRIPTION) Values   (2, ‘Programming’);
Insert into JOB   (JOB_ID, DESCRIPTION) Values   (3, ‘Administration’);
Insert into JOB   (JOB_ID, DESCRIPTION) Values   (10, ‘DBA’);
Insert into JOB   (JOB_ID, DESCRIPTION) Values   (5, ‘Pilot’);
Insert into JOB   (JOB_ID, DESCRIPTION) Values   (8, ‘Security’);

OK, ladies and gentlemen here goes an Oracle query that does the same. Rownum is our thing here, rownum will serve our purpose .I hope it would be helpful for you.

select job_id from
(select rownum r,job_id from job order by job_id desc)
where r=2;

This is another version I found on web

(SELECT job_id,row_number() OVER (ORDER BY JOB_ID DESC )r  FROM job)
WHERE r=2;

Both queries return


I hope this would help.

Please leave feedback or if you have better solution, please share.


The GNOME project is proud to release this new version of the GNOME desktop environment and developer platform. Among the hundreds of bug fixes and user-requested improvements, GNOME 2.26 has several highly visible changes: the inclusion of a new disc burning application, simpler file sharing and a generally smoother user experience. Learn more about GNOME 2.26 through the detailed release notes.

For more news, tech tutorials and tech information click here

ubuntu_logoThe next ubuntu stable version is going to be released on 23rd April 2009.If you want to order your free CDS use the following link

If you want to know new features in ubuntu 9.04 as follows

* Linux kernel version 2.6.28

* A new notification system

* Faster boot times

* GNOME 2.26 desktop environment

* Community desktop themes and brand new artwork

* Evolutionary EXT4 filesystem

* Support for many new devices (wireless, webcams, mobile phones, etc.)


Its almost ready🙂 Here is what Ubuntu team has to say

The Ubuntu team is happy to bring you the latest and greatest software the Open Source community has to offer. This is their latest result, the Ubuntu 9.04 release candidate, which brings a host of excellent new features.

Upgrading from Ubuntu 8.10

To upgrade from Ubuntu 8.10 on a desktop system, press Alt+F2 and type in “update-manager -d” (without the quotes) into the command box. Update Manager should open up and tell you: New distribution release '9.04' is available. Click Upgrade and follow the on-screen instructions.

To upgrade from Ubuntu 8.10 on a server system: install the update-manager-core package if it is not already installed; edit /etc/update-manager/release-upgrades and set Prompt=normal; launch the upgrade tool with the command sudo do-release-upgrade; and follow the on-screen instructions.


Get it while it’s hot. ISOs and torrents are available at: (Ubuntu Desktop, Server, and Netbook Remix) (Kubuntu) (Ubuntu MID) (Ubuntu Education Edition) (Xubuntu) (UbuntuStudio) (Mythbuntu) (Ubuntu ARM)