Dimiter Emilov Ivanov
Posted on:

29 Jun 2025
0

Omission of table indication: a general rule

in SQL / Tips and tricks for joins

"You can omit the table indication in the GROUP BY section if the column name is encountered only once throughout the joined tables" 

My question:


Is this generally true for all columns in all parts of the query? For example, I noticed that there is AVG(salary) instead of AVG(s.salary) and the query still works.

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Sivarajan Sivakumar
0
18
Cannot insert 999903 into the dept_emp table?
Harsha Dharmabandu
1
14
Resolved: foreign key : able to see foreign key in the table sales DDL tab , but the Foreign Keys tab is empty
lalit yadav
7
12
Resolved: M query fetch time increased after creating an index for the salaries table!
Snoor Salihi
0
10
Resolved: Drop table from the database
Ashakah Onome Andrew
0
10
Resolved: Salaries table is empty, showing Null
Francois Chouinard
1
10
Can you show the instructions to reproduce dept_manager_dup table?
Matt Birch
0
10
Error after Error: Can't create a table this time
Longyin Li
0
8
cant't create table in sql
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Geetanjali Juneja Upadhyay
0
6
15. sql subquires--Can you please help to find out why in the video you are using the dept_emp table
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?
Shelly Stanton
0
6
Should this be a select all records from the customers table?