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?
Give the full form of SQL.
State the significance of the following in DBMS :
(i) Forms
(ii) Reports
Define database
What is a relationship in databases? List its types.
What is meant by Database Partitioning?
Which is not a limitation of database?
State any two requirements that should be considered before making an investing decision to choose between 'Server database' or 'Desktop database'.
Give the shortcut that is used to select a row in Excel.
List any two types of storage devices in DBMS.
