@4:06 ~ The SQL Statement is: SELECT * FROM RelativeTypeT ORDER BY Description;
It seems that it would also be just as effective written as: SELECT Description FROM RelativeTypeT ORDER BY Description;
Is there a particular reason to SELECT * rather than the field?
Sami Shamma
@Reply 2 years ago
if the only results you want is Description, then
SELECT Description FROM RelativeTypeT ORDER BY Description; is perfectly fine.
if on the other hand you wanted all the fields in the Table, then
SELECT * FROM RelativeTypeT ORDER BY Description
Mark YoungOP
@Reply 2 years ago
That was pretty much my conclusion, just wanted to verify tho...
Thanks Sami!
Kevin Yip
@Reply 2 years ago
It is good practice to minimize data retrievals, so you want to retrieve only the fields you need, no more, no less. Therefore, SELECT * is often less desirable to SELECT field1, field2, etc., especially if the table has a lot of fields. Field size is important too in determining how much data you are retrieving. A numerical field only takes up a few bytes. But a text field can occupy hundreds, thousands, even millions of bytes or more. A long text field can hold gigabytes of text. In short, always practice caution when you use SELECT *.
Mark YoungOP
@Reply 2 years ago
Thanks for your input Kevin!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 4.