Echo Off/On

System will display the SQL Statement which are running when Echo is on and will not display when Echo is off

SQL Command
Set Echo On
Set Echo Off

How to find duplicate values using SQL

Assume, Table sample contains 3 rows

select * from sample;
+----+------------+
| id | Name       |
+----+------------+
|  1 | xyz        |
|  2 | Rajesh     |
|  3 | Rajesh     |
+----+------------+

Select name,count(*) from sample group by name;

The above query will group all the similar name
value into a group,count(*) will list the number
of counts for the value in the group.

+------------+----------+
| Name       | count(*) |
+------------+----------+
|Rajesh      |        2 |
| ABC        |        1 |
+------------+----------+

Now we can able to identify the duplicate rows,
 but how to list the
duplicate rows alone.


Select Name,count(*) from sample group by
name having count(*) > 1;

+------------+----------+
| Name       | count(*) |
+------------+----------+
|Rajesh      |        2 |
+------------+----------+
As we know duplicate rows has the count greater
than 1. So we are using the Having clause to
check which group contains the counts greater than 1

State Bank ATM Machine

This time, I come with the defects of SBI ATM machine. Here I am trying to get my mini stmt. The Screen offered me two types of account, one is SB and another one is Current account. I was suppose to touch a command called SB account in the screen,(since ATM is Touch screen machine) but the touch screen is not working for SB Type. So I selected Current account in the screen by just brushing my finger over the current account command in the screen, ATM should not provide me mini stmt, since I am holding SB account. But the ATM gave me mini stmt and that too for the correct balance. Here it should throw a error message like "You does not hold current account"

Testing the MOVIES

Suddenly I got a thought, why can't I test the movies and look for logic loop holes in the movies, as tester I always used to find something which goes wrong. So I started to search for logic loop holes in the movies during the process, on Saturday, I came across a climax scene of Tamil movie called whistle. I will describe the climax scene and logical issue.

Scene as follows

Both Hero and Heroine are standing in front of the villain(Lady called sherin) and a inspector lying down with injuries. Villain(sherin) holding a gun and pointing towards the hero and heroine with a cunning smile on her face(trying to kill them). In the rescue process,Inspector throws something hard at the hand of villain, after hitting hard villain drops the gun and heroine collects the gun and now gun is pointed to villain.Both hero and inspector ask heroine to shoot the villain.But she refuses to shoot(Because villain was very good friend of heroine before). Mean time villain takes advantage and broke a bottle and try to kill heroine, immediately inspector takes a gun from his socks and shoot the villain and the Movie ends happily.

My question about the logic is

Why does inspector doesn't use his gun at the first attempt itself rather than throwing something hard at the villain hands, and later using his gun. Inspector got the chance to kill her but he made villain to drop the gun and ask the heroine to kill her when she refuse, inspector kill the villain. What a Drama and twist.

Stupid isn't.

Microsoft closes Encarta

It seems Microsoft closes it Encarta encyclopedia. By the end of June Encarta software removed from store and by the end of December, website will be removed. The reason might be Microsoft lost its battle with Wikipedia. Since most of the content is outdated and cannot survive the Battle with Wikipedia(Text based online encyclopedia whereas Encarta is audio and graphics based encyclopedia). Check the FAQ in the official site

For more information click here

How to Detect a memory leak with Load runner

I came across an excellent article for memory leak.
Check the URL

http://motevich.blogspot.com/2007/08/how-to-detect-memory-leaks-with.html

Xenu a broken link finder

I supposed to find broken links in one of my project, which I did that manually. It was huge task as links kept going on. I thought if I can automate that it would be easier for me. I started googling and found Xenu

Xenu is an open source tool, used to find broken links in the websites. It is quick and easy to install and it total occupying space is less than 3 MB.

But I never used that tool in my project, it went to release before I get used with the tool.