Attribute Specification in Select Clause



Rating - 3/5
493 views

The asterisk symbol “ * ” can be used in the select clause to denote “all attributes.”
Thus, the use of instructor.* in the select clause of the query:

These Topics Are Also In Your Syllabus
1 Relational Databases link
2 Relational Databases link
You May Find Something Very Interesting Here. link
3 Data Storage and Querying link
4 Transaction Management link
5 Types Of Systems link

select instructor.*
from instructor, teaches
where instructor.ID= teaches.ID;

These Topics Are Also In Your Syllabus
1 Nested Subqueries link
2 Nested Subqueries link
You May Find Something Very Interesting Here. link
3 Modification of the Database link
4 Join expressions link
5 Types Of Systems link

indicates that all attributes of instructor are to be selected. A select clause of the
form select * indicates that all attributes of the result relation of the from clause
are selected.

These Topics Are Also In Your Syllabus
1 Database Users and Administrators link
2 History of Database Systems link
You May Find Something Very Interesting Here. link
3 Structure of Relational Databases link
4 Database Schema link
5 Keys link

Rating - 3/5
451 views

Advertisements
Rating - 3/5