Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement [code]DROP table test1,test2,test3[/code]......

Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...

Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Numb...