Advertisements
Advertisements
प्रश्न
What is the difference between the Select and Project commands?
अंतर स्पष्ट करें
Advertisements
उत्तर
| Select | Project | |
| The SELECT operation(o) is used for selecting a subset with tuples according to a given selection condition. | The projection method(n) eliminates all attributes of the input relation but those mentioned in the projection list. | |
| The SELECT operation (o) selects filters out all tuples that do not satisfy the condition. | The projection method defines a relation that contains a vertical subset of Relation. | |
| Symbol: σ | Symbol: π | |
| General Form: σ (R) c Example: σ = “Big Data” (STUDENT) course |
Example: π (STUDENT) course |
|
shaalaa.com
क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
APPEARS IN
संबंधित प्रश्न
What is meant by cell address?
State any one method of removing data from a cell in a spreadsheet.
Give the full form of SQL.
__________ is a collection of related data.
What are the ACID properties?
List the components of storage manager.
What is the full form of DBMS?
What is not a DBMS?
Give the term for the following:
DBMS creates a file that contains a description of the data stored in the database.
Differentiate between Database state and database schema.
