• Register
1 vote
101 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

Please log in or register to answer this question.

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.

8 5 2
10,530 points

Related questions

0 votes
1 answer 20 views
20 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 Oct 19, 2020 Code Learner 5.3k points
0 votes
2 answers 49 views
49 views
Problem: The six clauses of the SELECT statement must be coded in the following order:?
asked Apr 18, 2020 ArifulIslam 5.6k points
0 votes
1 answer 105 views
105 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, 2020 jwilliam 3.9k points
0 votes
1 answer 4 views
4 views
What is the difference between where and having in SQL?
asked Oct 11, 2020 sikandar 2.4k points
0 votes
1 answer 106 views
106 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
0 votes
1 answer 4 views
4 views asked Dec 5, 2020 miki 1.9k points
0 votes
1 answer 10 views
10 views asked Oct 17, 2020 SapperIt 1.2k points
0 votes
1 answer 187 views
187 views
Problem: I am new and learning, I need help, can anyone help by filling in the blanks? When CSS is coded in the body of the web page as an attribute of an HTML tag it is called _____?
asked Feb 21, 2020 maddi86 5.4k points
0 votes
1 answer 7 views
0 votes
1 answer 7 views