Home » Finance Homes Digest » The Difference Between Select * and Select A. * [Closed]

The Difference Between Select * and Select A. * [Closed]

Sarah Jenkins • • 1 min read
The Difference Between Select * and Select A. * [Closed]

I am new to SQL can someone help me understand why do we use Select .* in sql server ? And why is it different from just select * from table name In some cases we use statements like select .*, firstname , lastname from employee. Just a bit confused.

4

1 Answer

.* means, select all columns of a table

SELECT A.*,B.Id from A,B select all columns of A and only Id column of B.

2
Sarah Jenkins
Author

Sarah Jenkins

Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.