Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 26-11-2009
Member
 
Join Date: Nov 2009
Posts: 95
What is tuple variables in SQL?

Hi Guys,

Is anybody know about the tuple variables in SQL?
Actually one of my friend asked this question to me. I don't know anything about the tuple variable. What is tuple variables in SQL? Can I we use tuple variables in the FROM clause of the SQL? Is it any special type of variable ?

Please let me know something about tuple variables, So that I can help my friend to understand it...
Reply With Quote
  #2  
Old 26-11-2009
Member
 
Join Date: May 2008
Posts: 2,293
Re: What is tuple variables in SQL?

Hi Friend,

According to my SQL knowledge, in "from" clause we can define "Tuple variable".

See the below example of the tuple variable:

Quote:
SELECT DISTINCT EMP_NAME, S.SAL#

From BANK AS P, SAL AS S

WHERE P.SAL#=P.SAL#

//Note that keyword "AS" is optional.
Reply With Quote
  #3  
Old 26-11-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: What is tuple variables in SQL?

You can use "tuple variable" within the expression. The function of the tuple operator is like "Rename" operator. I don't know more about the tuple variable.See if something below can help you:

Example:

Quote:
SELECT DISTINCT G.perName

From Division K, Division G

WHERE K.perPlace="Delhi" AND G.ID > K.ID
Reply With Quote
  #4  
Old 26-11-2009
Member
 
Join Date: May 2008
Posts: 2,383
Re: What is tuple variables in SQL?

Tuple variables are used in the SQL claus known as FROM. In the following example, 'stud_name' field represent the name of the table on which you want apply tuple , And 'id' is the field which is common between two tables i.e school & Status.

Quote:
select stud_name, S.id ,P.percentage

from school S, Status P

where S.id = P.id
__________________
The FIFA Manager 2009 PC Game
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What is tuple variables in SQL?"
Thread Thread Starter Forum Replies Last Post
How to use Listings and Tuple in Python? Dante i Software Development 4 04-01-2011 03:50 AM
How to insert value into tuple? MKAIF Software Development 5 22-02-2010 07:20 PM
What are the PHP Variables? shivendra Software Development 5 28-01-2010 07:05 PM
SQL problem if tuple is already in the database Macbeth Software Development 4 17-11-2009 09:02 PM
c# environment variables EULALIA Software Development 3 13-07-2009 02:23 PM


All times are GMT +5.5. The time now is 11:18 AM.