Attribute Specification in Select Clause



Rating - 3/5
543 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:

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

These Topics Are Also In Your Syllabus Attribute Specification in Select Clause
1 Types of Operating Systems - Batch operating system, Time-sharing systems, Distributed OS, Network OS, Real Time OS link
2 Basic Structure of SQL Queries link
You May Find Something Very Interesting Here. Attribute Specification in Select Clause link
3 Introduction to Database Security Issues link
4 Introduction to Database Security Issues 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.


Rating - 3/5
468 views

Advertisements