• Register
1 vote
156 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 6 2
10,530 points

Related questions

0 votes
1 answer 3 views
3 views
Problem How can I use group functions in the where clause ?
asked Apr 7 salim1 39k points
0 votes
1 answer 3 views
3 views
Problem: I am having a problem with this simple sql query. When I use the string directly in the WHERE clause like this $query_getShows = "SELECT * FROM toho_shows WHERE toho_shows.show ='gothaf'"; Any help would be appreciated. Thank you!
asked Mar 27 ummesalma 25.2k points
0 votes
1 answer 2 views
2 views
Question: How would i write this sql statement without a hard coded value? resultSet = statement .executeQuery("select * from myDatabase.myTable where name = 'john'"); // this works rather have something like: String name = "john"; resultSet = statement . ... ); // Unknown column 'john' in 'where clause' at // sun.reflect.NativeConstructorAccessorImpl.newInstance0...etc... Thanks in advance.
asked 2 days ago Atik03 10.1k points
0 votes
1 answer 3 views
3 views
Problem: As I mentioned in my previous query, I'm having difficulties with my learning; I've tried searching the web but haven't been able to find adequate information; could you assist me in continuing my project?
asked Mar 30 tuhin1 48.9k points
0 votes
1 answer 47 views
47 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 9.2k points
0 votes
2 answers 110 views
110 views
Problem: The six clauses of the SELECT statement must be coded in the following order:?
asked Apr 18, 2020 ArifulIslam 7.5k points
0 votes
1 answer 4 views
4 views
Problem: I'll make a submission for a response to my question. Please, I have searched the internet but have not found any useful material, and I am now having trouble continuing my studies.
asked Mar 30 tuhin1 48.9k points
0 votes
1 answer 5 views
5 views
Problem: Hi I need the solution of this problem please;; column must appear in the group by clause
asked Mar 20 PkGuy 13.1k points
0 votes
1 answer 154 views
154 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 3 views
3 views
Problem: Can anyone help me out?
asked Apr 4 niyatiry 3.2k points