Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
What will be the result of below query

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
Author Message
sivatechdrive

Active User


Joined: 17 Oct 2004
Posts: 160
Location: hyderabad
PostPosted: Wed Nov 10, 2004 5:28 pm    Post subject: What will be the result of below query
 Reply with quote
what will be the result of below query


select '1' ,empno from emptable
where ssn= 000010


the table has empid,empno,ssn fields
what does is mean giving literals in a query ( '1')

Thanks
Siva
Back to top
View user's profile Send private message
References
PostPosted: Wed Nov 10, 2004 5:28 pm    Post subject: Re: What will be the result of below query Reply with quote
anuradha

Global Moderator


Joined: 06 Jan 2004
Posts: 257
PostPosted: Wed Nov 10, 2004 8:00 pm    Post subject:
Reply with quote
Hi Siva,

Suppose the emptable has rows like:

10 200 000010
20 400 000020

then the result of the query is:

1 200 000010
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1