This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design 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: 1041
    
    4
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: 3640
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: 32507
    
214

Create


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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: 4003
    
  18

FOREIGN KEY


The mind is a strange and wonderful thing. I'm not sure that it will ever be able to figure itself out, everything else, maybe. From the atom to the universe, everything, except itself.
Michael Matola
whippersnapper
Ranch Hand

Joined: Mar 25, 2001
Posts: 1784
    
    4
COALESCE
Ryan McGuire
Ranch Hand

Joined: Feb 18, 2005
Posts: 1041
    
    4
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: 1779
    
  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
 
It's not a secret anymore!