permaculture playing cards*
The moose likes Meaningless Drivel and the fly likes Game on SQL Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Other » Meaningless Drivel
Bookmark "Game on SQL" Watch "Game on SQL" New topic
Author

Game on SQL

Muse Ran
Ranch Hand

Joined: Sep 17, 2008
Posts: 317
lets play simple game, SQL key words...

SELECT


Tomorrow will surely be a new day!!!
Lester Burnham
Rancher

Joined: Oct 14, 2008
Posts: 1337
Offsides!
S. Nitesh
Ranch Hand

Joined: Jan 15, 2010
Posts: 36
    
    1

TRUNCATE
ankur rathi
Ranch Hand

Joined: Oct 11, 2004
Posts: 3830
Lester Burnham wrote:Offsides!


where

David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

distinct
Teja Saab
Rancher

Joined: Mar 08, 2010
Posts: 152
Join


SCEA 5, SCJD,SCWCD,SCJP,PMP,IBM-SOA Solution designer,IBM-XML
Wouter Oet
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

group by


"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
Teja Saab
Rancher

Joined: Mar 08, 2010
Posts: 152
insert into
Ryan McGuire
Ranch Hand

Joined: Feb 18, 2005
Posts: 1013
    
    3
LEFT OUTER JOIN
...if you know what I mean.
Muse Ran
Ranch Hand

Joined: Sep 17, 2008
Posts: 317
Ryan McGuire wrote:LEFT OUTER JOIN
...if you know what I mean.


...yes

Even i know RIGHT OUTER JOIN

Chetan Parekh
Ranch Hand

Joined: Sep 16, 2004
Posts: 3636
SELECT * FROM SKY;


My blood is tested +ve for Java.
Ashok A Kumar
Greenhorn

Joined: Jul 01, 2010
Posts: 19
DELETE
Chandrasekar Venkatraman
Greenhorn

Joined: Aug 23, 2010
Posts: 22

DROP


Learn to live.. Live to learn..
http://helptotheneeded.blogspot.com
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31054
    
232

Create


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Chandrasekar Venkatraman
Greenhorn

Joined: Aug 23, 2010
Posts: 22

Order By
Sunny Bhandari
Ranch Hand

Joined: Dec 06, 2010
Posts: 448

GRANT


Java Experience
Chandrasekar Venkatraman
Greenhorn

Joined: Aug 23, 2010
Posts: 22

REVOKE
Stephan van Hulst
Bartender

Joined: Sep 20, 2010
Posts: 3649
    
  17

FOREIGN KEY
Michael Matola
whippersnapper
Ranch Hand

Joined: Mar 25, 2001
Posts: 1757
    
    3
COALESCE
Ryan McGuire
Ranch Hand

Joined: Feb 18, 2005
Posts: 1013
    
    3
GetDate()

Just don't tell my wife.
Kaustubh G Sharma
Ranch Hand

Joined: May 13, 2010
Posts: 1281

IN


No Kaustubh No Fun, Know Kaustubh Know Fun..
palanisamy subramani
Greenhorn

Joined: Aug 30, 2010
Posts: 29
Between
Kaustubh G Sharma
Ranch Hand

Joined: May 13, 2010
Posts: 1281

isnull
Janeice DelVecchio
Saloon Keeper

Joined: Sep 14, 2009
Posts: 1732
    
  12

NATURAL JOIN

... hehehehe


When you do things right, people won't be sure you've done anything at all.
Harsha Ka
Ranch Hand

Joined: Mar 14, 2010
Posts: 45

sysdate


SCJP 1.6,Preparing (Tryin to prepare) for scwcd
Kaustubh G Sharma
Ranch Hand

Joined: May 13, 2010
Posts: 1281

ASC
Wouter Oet
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

Database
Kaustubh G Sharma
Ranch Hand

Joined: May 13, 2010
Posts: 1281

DESC
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Game on SQL