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 the use of legends in a chart?
What is the difference between .importing and exporting of a database?
Define database
A tuple is also known as ______
The ______ diagram gives a logical structure of the database graphically?
______ is known as skeleton of database.
Constraints are used to ______.
State or snapshot of a database at any instance is known as ______.
Give the shortcut that is used to select a row in Excel.
Why is database testing important?
