menu
  • Register

Expressions coded in the where clause?

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
Delete without Where clause
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
The six clauses of the select statement must be coded in the following order:?
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
Column must appear in the group by clause or be used in an aggregate function
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
Difference between where and having in sql
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
An expression of non-boolean type specified in a context where a condition is expected
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
If condition in where clause in sql
asked Dec 5, 2020 miki 1.9k points
0 votes
1 answer 10 views
10 views
Select * from table where id =
asked Oct 17, 2020 SapperIt 1.2k points
0 votes
1 answer 187 views
187 views
When css is coded in the body of the web page as an attribute of an html tag it is called ________?
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
7 views
I need to know more about the difference between cast and Convert in SQL server
asked Oct 27, 2020 miki 1.9k points
0 votes
1 answer 7 views
7 views
How to view the stored procedure in SQL server ?
asked Oct 27, 2020 miki 1.9k points
Dark theme