Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
What could be the reason that the MySQL statement 'SELECT AVG (SALARY) FROM EMP' generates an inaccurate output?
Home
DB2
What could be the reason that the MySQL statement 'SELECT AVG (SALARY) FROM EMP' generates an...
0
votes
asked
Feb 28
in
DB2
by
john ganales
What could be the reason that the MySQL statement 'SELECT AVG (SALARY) FROM EMP' generates an inaccurate output?
mysql
statement
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Feb 28
by
john ganales
The reason for the statement generating an inaccurate outcome is that SALARY has not been declared to have NULL values and, at the same time, the employees whose salary is not known are also counted.
Related questions
0
votes
Q: What could be the reason that the MySQL statement
asked
Feb 27
in
DB2
by
Robin
mysqlstatement
0
votes
Q: A customer needs to run a MySQL database that easily scales. Which AWS service should they use?
asked
Sep 7, 2022
in
AWS
by
sharadyadav1986
mysql
database
aws
0
votes
Q: How to Install NGINX, PHP, MySQL, SSL & WordPress on Ubuntu
asked
May 14, 2023
in
NGINX
by
john ganales
install
nginx
php
mysql
ssl
&
wordpress
ubuntu
0
votes
Q: What is the use of the SELECT statement?
asked
Mar 25, 2023
in
Oracle
by
john ganales
select
statement
0
votes
Q: What is an Expression? What is a Statement? Difference between Expression and Statement?
asked
Sep 12, 2022
in
Scala Constructs
by
Robin
scala
expression
statement
0
votes
Q: How to perform EXPLAIN for any Dynamic SQL statement?
asked
Feb 29
in
Sql
by
Robindeniel
sql
statement
0
votes
Q: What is the pass statement in Python?
asked
May 10, 2023
in
Python Flask
by
john ganales
pass
statement
i
0
votes
Q: Please provide the example with syntax of Switch statement in Golang
asked
Apr 27, 2023
in
GoLang
by
Robin
switch
statement
golang
0
votes
Q: How can the FIRSTNAME and the LASTNAME from the EMP table be concatenated to generate complete names?
asked
Feb 27
in
DB2
by
Robin
emp
table
0
votes
Q: What would be the output of below SQL statement, select empName from Employee order by 2 desc:
asked
Mar 18, 2023
in
Oracle
by
GeorgeBell
oracle-interview-questions-answers
...