Tuesday, May 22, 2007

SQL Syntax - SELECT,UPDATE and DELETE

Below is the Lists of possible syntax for SELECT,UPDATE and DELETE

SELECT Syntax - Get Information from a table in database
SELECT ColumnName1,ColumnName2, ColumnName3 FROM TableName
SELECT DISTINCT ColumnName FROM TableName

SELECT COUNT (ColumnName) FROM TableName
SELECT ColumnName FROM TableName WHERE ColumnName = value
SELECT ColumnName FROM TableName WHERE ColumnName1 = value AND ColumnName2 = value

SELECT ColumnName FROM TableName WHERE ColumnName1 = value OR ColumnName2 = value
SELECT ColumnName FROM TableName WHERE ColumnName IN (Value1,Value2)
SELECT ColumnName FROM TableName WHERE ColumnName BETWEEN (Value1 AND Value2)

SELECT ColumnName FROM TableName WHERE ColumnName Like '%Value1%'
SELECT ColumnName FROM TableName ORDER BY ColumnName
SELECT ColumnName1 , SUM(ColumnName2 ) FROM TableName GROUP BY ColumnName1 HAVING (Arithematic Condition)


UPDATE Syntax
UPDATE TableName SET ColumnName = Value WHERE {Condition}
UPDATE TableName SET ColumnName = Value WHERE ColumnName = value

DELETE Syntax
DELETE TableName WHERE {Condition}
DELETE TableName WHERE ColumnName = value

7 comments:

buy wow gold said...

When the Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.
game4power.
The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as mttgamingI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just agamegold lived happily ever after!.

buy wow gold said...

When the Wow Gold wolf finally found the wow gold cheap hole in the chimney he crawled cheap wow gold down and KERSPLASH right into that kettle of water and that was cheapest wow gold the end of his troubles with the big bad wolf.

game4power.
The next day the Buy Wow Goldlittle pig invited hisbuy gold wow mother over . She said "You see it is just as Cheapest wow goldI told you. The way to get along in the world is to do world of warcraft gold things as well as you can." Fortunately for that little pig, he buy cheap wow gold learned that lesson. And he just wow gold lived happily ever after!.

梦中林 said...

A slim, wide-eyed mygamegoldwoman almost human in virbanksfeatures eyed agamegold the pair. Her nose was sharp, but very elegant. She had tbcgold a pale, trade4gamebeautiful face the color of ivory, and veryge for hair she wore a wondrous mane of downy feathers. Her gown fluttered as she walked—on two delicate worldofgolds but still sharply-taloned feet. “Awake, awake you are,” she said with a pvp365 slight frown. “You should rest, rest.” Krasus bowed to her. “I am ezmmorpg grateful for your ighey hospitality, mistress, but I am well enough to continue on9a9z now.” She cocked her head as a bird might, giving the mageltk365 a reproving look. “No, no…too soon, toogold4guild soon. Please, sit.” The duo looked around u4game and discovered that two chairs, made in the same ready4game fashion as the nest, waited behind happygolds them. Malfurion waited for Krasus, who finally nodded and sat.

Gayatri said...

we specialize in the manufacturing of http://www.gdqikang.com Coldroom panel, http://www.gdqikang.comCold storage, http://www.gdqikang.com Cold box, http://www.gdqikang.com Stainless steel workbench, http://www.gdqikang.com Stainless steel rack, http://www.gdqikang.com Stainless steel shelving, http://www.gdqikang.com Beer cooler, http://www.gdqikang.com Ice cream cabinet, http://www.gdqikang.com Ice cream display, http We specialise in the manufacturing of http://www.gdqikang.com Coldroom,://www.gdqikang.com Supermarket display, http://www.gdqikang.com Supermarket shower, http://www.gdqikang.com Fridge, http://www.gdqikang.com Freezer, http://www.gdqikang.com Upright showcase, http://www.gdqikang.com Kitchen refrigeration, http://www.gdqikang.com Ice maker, http://www.gdqikang.com Fryer, http://www.gdqikang.com Gas driddl, http://www.gdqikang.com BBQ, http://www.gdqikang.com Bar-becue, http://www.gdqikang.com Oven, http://www.gdqikang.com Warmer, http://www.gdqikang.com Cake display cabinet, http://www.gdqikang.com Cake showcase,http://www.gdqikang.com Bakery showcase, http://www.gdqikang.com Pastry display, http://www.gdqikang.com Hot food display, http://www.gdqikang.com Food warmer display, http://www.gdqikang.com Food display warmer

Gayatri said...

This world is just getting crazy for the www.powerlevelingspecialists.com online games, and the most recent buzzword in the www.powerlevelingspecialists.com world of gamers and especially when it’s Massive www.powerlevelingspecialists.com Multiplayer Online Role Playing Games www.powerlevelingspecialists.com (MMORPG) is www.powerlevelingspecialists.com power leveling . Such games as www.powerlevelingspecialists.com World of Warcraft , www.powerlevelingspecialists.com Warhammer online and www.powerlevelingspecialists.com Age of Conan lets you assume various roles as you www.powerlevelingspecialists.com explore adventure and quest across vast worlds. These www.powerlevelingspecialists.com games are so highly addictive some gamers have even gone as far as saying it’s similar to a Crack Cocaine addiction; just try it once and you’re hooked. These games have even been the cause of death, suicide, divorce and even bankruptcy in the most severe cases.www.powerlevelingspecialists.com/index2.php Home www.powerlevelingspecialists.com/about.php About Us www.powerlevelingspecialists.com/contact.php Contact Us www.powerlevelingspecialists.com/powerleveling.php Powerleveling www.powerlevelingspecialists.com/gold.php Buy Gold www.powerlevelingspecialists.com/reputationpl.php Reputation www.powerlevelingspecialists.com/professionpl.php Professions www.powerlevelingspecialists.com/burningcrusade.php Burning Crusade www.powerlevelingspecialists.com/purchase.php Purchase Merchandise www.powerlevelingspecialists.com/expedition.php Expeditions www.powerlevelingspecialists.com/forum Forums www.powerlevelingspecialists.com/gold.php WOW www.powerlevelingspecialists.com/gold.php WOW gold | www.powerlevelingspecialists.com/gold.php Warcraft World | www.powerlevelingspecialists.com/gold.php World of Warcraft | www.powerlevelingspecialists.com/burningcrusade.php MMORPG | www.powerlevelingspecialists.com/burningcrusade.php Role Playing Game | www.powerlevelingspecialists.com/powerleveling.php WOW Power Leveling Specialists | www.powerlevelingspecialists.com/powerleveling.php World of Warcraft Power Leveling Specialists | www.powerlevelingspecialists.com/powerleveling.php Power Leveling Specialists | www.powerlevelingspecialists.com/powerleveling.php WOW Powerleveling | www.powerlevelingspecialists.com/professionpl.php Profession powerleveling | www.powerlevelingspecialists.com/purchase.php Wow buy gold online | www.powerlevelingspecialists.com/purchase.php Wow gold for cash | www.powerlevelingspecialists.com/gold.php World of Warcraft gold | www.powerlevelingspecialists.com/powerleveling.php World of Warcraft powerleveling www.powerlevelingspecialists.com/professionpl.php World of Warcraft professions | www.powerlevelingspecialists.com/reputationpl.php Cheap powerleveling | www.powerlevelingspecialists.com/reputationpl.php reliable powerleveling | www.powerlevelingspecialists.com/powerleveling.php Powerleveling info | www.powerlevelingspecialists.com/purchase.php buy gold online | www.powerlevelingspecialists.com/expedition.php gain levels quickly | www.powerlevelingspecialists.com/expedition.php leveling warcraft world | www.powerlevelingspecialists.com/expedition.php leveling tip warcraft world | www.powerlevelingspecialists.com/reputationpl.php leveling service warcraft world | www.powerlevelingspecialists.com/reputationpl.php fast leveling warcraft world | www.powerlevelingspecialists.com/expedition.php bots leveling warcraft world www.powerlevelingspecialists.com Age of conan www.powerlevelingspecialists.com warhammering

梦中林 said...

A slim, wide-eyed mygamegoldwoman almost human in virbanksfeatures eyed agamegold the pair. Her nose was sharp, but very elegant. She had tbcgold a pale, trade4gamebeautiful face the color of ivory, and veryge for hair she wore a wondrous mane of downy feathers. Her gown fluttered as she walked—on two delicate worldofgolds but still sharply-taloned feet. “Awake, awake you are,” she said with a pvp365 slight frown. “You should rest, rest.” Krasus bowed to her. “I am ezmmorpg grateful for your ighey hospitality, mistress, but I am well enough to continue on9a9z now.” She cocked her head as a bird might, giving the mageltk365 a reproving look. “No, no…too soon, toogold4guild soon. Please, sit.” The duo looked around u4game and discovered that two chairs, made in the same ready4game fashion as the nest, waited behind happygolds them. Malfurion waited for Krasus, who finally nodded and sat.
brogameswagvaultgoldsoonoforuigxethsale

christi parks said...

I am not a programmer but I have this SQL subject this session and have to prepare for it. What all topics should be covered in it?
And has anyone studied from this course www.wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance...
would really appreciate help