Register

SQL Duplicate columns

• retagged by
1,042 views
2 2 votes
Assume i have two tables R(A,B) and S(A,D)

1. Select * from R,S

2. Select * from R,S where R.A>S.A

What will be the name/number of columns on both of these cases?

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Token BucketNext → · Lattice
← Previous in category · Dbms relation algebr...Next in category → · DBMS Relational Alge...
Position:
Show:

Related questions

1 1 vote
1 1 answer
4.9k
4.9k views
Isha Gupta asked Jun 12, 2016
4,874 views
which operation is used to extract specific columns from a table
which operation is used to extract specific columns from a table?
1 1 vote
2 2 answers
65
65 views
GO Classes asked 3 days ago
65 views
GO Classes DPP | GATE CS, DA | DBMS | Duplicate Tuples
Consider the relation $R(a,b)$. The relation may contain duplicate tuples.Which of the following queries are guaranteed not to contain duplicate tuples, regardless of the...
0 0 votes
1 1 answer
109
109 views
GO Classes asked 6 days ago
109 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
The database contains relations $\mathrm{animals}$ and $\mathrm{visits}$, with $\mathrm{aid}$ identifying an animal.Which SQL query returns the names of animals that visi...
0 0 votes
1 1 answer
98
98 views
GO Classes asked 6 days ago
98 views
GO Classes DPP | GATE CS, DA | DBMS | SQL
The $\mathrm{Employee}$ relation contains:$$\begin{array}{|c|c|c|c|} \hline \mathrm{EmployeeNo} & \mathrm{Name} & \mathrm{DateOfBirth} & \mathrm{Department} \\ \hline 000...