Geeks Talk

Prepare for your Next Interview




What does this mean!!

This is a discussion on What does this mean!! within the DB2 forums, part of the Databases category; Hi friends, I came across a strange thing today. There was a query select *from emp order by name,sal -- I dnt know what does -- stand for in the above ...


Go Back   Geeks Talk > Databases > DB2

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 04-03-2008
Junior Member
 
Join Date: Sep 2007
Location: Bangalore
Posts: 13
Thanks: 1
Thanked 1 Time in 1 Post
Divya.B.V is on a distinguished road
What does this mean!!

Hi friends,

I came across a strange thing today. There was a query

select *from emp order by name,sal --

I dnt know what does -- stand for in the above query. I couldnt find out the difference with -- or without --. Please help me understand this.

Thanks in advance,
Divya
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-03-2008
Moderator
 
Join Date: Jun 2007
Location: Bangalore,India
Posts: 1,369
Thanks: 7
Thanked 123 Times in 111 Posts
debasisdas will become famous soon enoughdebasisdas will become famous soon enough
Re: What does this mean!!

-- is not part of the syntax.

-- anything after the double-hyphen is a comment in DB2
Reply With Quote
The Following User Says Thank You to debasisdas For This Useful Post:
  #3 (permalink)  
Old 04-03-2008
Junior Member
 
Join Date: Sep 2007
Location: Bangalore
Posts: 13
Thanks: 1
Thanked 1 Time in 1 Post
Divya.B.V is on a distinguished road
Thumbs up Re: What does this mean!!

Quote:
Originally Posted by debasisdas View Post
-- is not part of the syntax.

-- anything after the double-hyphen is a comment in DB2
thanks buddy, You are helpful.
Reply With Quote
  #4 (permalink)  
Old 05-16-2008
Junior Member
 
Join Date: May 2008
Location: Burlington MA
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Jyelamanchili is on a distinguished road
Re: What does this mean!!

We use -- in QMF/QMF for WIndows/SPUFI to comment out any thing.

He must have started to type comments about an SQL left the -- in there
Reply With Quote
Reply

  Geeks Talk > Databases > DB2


Thread Tools
Display Modes



All times are GMT -4. The time now is 05:40 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved