• Register
1 vote
70 views

Problem:

Can anyone help it was actually asked in exam as following and I need to know whether my answer was right or not?

Expressions coded in the WHERE clause?

  • can use non-aggregate search conditions but can't use aggregate search conditions
  • must refer to columns in the SELECT clause
  • can use either aggregate search conditions or non-aggregate search conditions
  • can use aggregate search conditions but can't use non-aggregate search conditions
 
7 5 3
5,380 points

1 Answer

0 votes

Solution:

It's very simple as  answer is : can use non-aggregate search conditions but can't use aggregate search conditions.

For your reference you can go through:

https://whereugo.org/where/the-six-clauses-of-the-select-statement-must-be-coded-in-the-following-order/expressions-coded-in-the-where-clause/

Hope you got the right solution.

7 4 2
10,530 points

Related questions

0 votes
1 answer 3 views
3 views
Problem: I want to know what happens if I use delete command without WHERE clause? Does it make any difference if I skip the WHERE clause?
asked 1 day ago Sheeza 2k points
0 votes
2 answers 33 views
33 views
Problem: The six clauses of the SELECT statement must be coded in the following order:?
asked Apr 18 ArifulIslam 5.7k points
0 votes
1 answer 67 views
67 views
Problem : I want to select a maximum avg for each cname in my table. SELECT cname, wmname, MAX(avg)  FROM makerar GROUP BY cname; But I will get the below error, ERROR:  column "makerar.wmname" must appear in the GROUP BY clause or be used in an   aggregate ... )  FROM makerar GROUP BY cname; How can I go about fixing above error? Note: This table is the VIEW created from the previous operation.
asked Jan 22 jwilliam 3.9k points
0 votes
1 answer 2 views
2 views
What is the difference between where and having in SQL?
asked Oct 11 sikandar 2.4k points
0 votes
1 answer 77 views
77 views
Problem : I am facing following error with the below query in SQL Server 2012. An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN'. SQL Query: CREATE FUNCTION [dbo].[GetMYPMResources](@UserResourceNo ... JOIN JobTask t ON t.JobTaskNo = m.JobTaskNo WHERE t.TaskManagerNo = @UserResourceNo OR t.AlternateTaskManagerNo = @UserResourceNo ) RETURN END
asked Dec 4, 2019 alecxe 7.5k points