About Question enthuware.oce-jpad.v6.2.490 :
Moderator: admin
-
- Posts: 13
- Joined: Mon Apr 18, 2016 2:05 pm
- Contact:
About Question enthuware.oce-jpad.v6.2.490 :
The explanation to option 4 is wrong. COUNT(), MIN() and MAX() can be used without a GROUP BY clause. But they can only be used in side a select clause.
For example this is valid:
SELECT COUNT(o)
FROM Order o
cheers
For example this is valid:
SELECT COUNT(o)
FROM Order o
cheers
-
- Posts: 358
- Joined: Fri Nov 29, 2013 8:26 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
Hi, Supafly,
Which test and which question no. this question belongs?
But this is not valid:
Select o.id, count(o) from Order o because group by clause does not exist.
When there are more than one path in the select clause with aggregate functions (count, max, min....), the group by clause is needed.
Which test and which question no. this question belongs?
But this is not valid:
Select o.id, count(o) from Order o because group by clause does not exist.
When there are more than one path in the select clause with aggregate functions (count, max, min....), the group by clause is needed.
-
- Site Admin
- Posts: 10113
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
The explanation doesn't say that you cannot use count without group by at all. It says you cannot mix grouped columns and non-grouped columns without a group by.
This explanation is in context of the option 5:
select s.firstname, count(p) from Student s left join s.presentations p
Here, you cannot mix s.firstname and count(p) without a group by for firstname.
Himai, this is in test 3, q 47. But you can simply open the question by doing control+q and entering 2.490 in ETS Viewer.
HTH,
Paul.
This explanation is in context of the option 5:
select s.firstname, count(p) from Student s left join s.presentations p
Here, you cannot mix s.firstname and count(p) without a group by for firstname.
Himai, this is in test 3, q 47. But you can simply open the question by doing control+q and entering 2.490 in ETS Viewer.
HTH,
Paul.
If you like our products and services, please help us by posting your review here.
-
- Posts: 13
- Joined: Mon Apr 18, 2016 2:05 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
That is true, i misread the explanation.
-
- Posts: 2
- Joined: Tue Jul 04, 2017 4:00 am
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
Looks like logical contradiction. I think answer 1 is also correct. Because we are not having multiple students with same name therefore with or without grouping we get the same result.
- Attachments
-
- duplicate_vs_unique.png (69.2 KiB) Viewed 9341 times
-
- Site Admin
- Posts: 10113
- Joined: Fri Sep 10, 2010 9:26 pm
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
No, it is not contradictory. "First names are unique" implies that no two students have same first name. Duplicate rows in the results will be there if same student makes multiple presentations.
If you like our products and services, please help us by posting your review here.
-
- Posts: 1
- Joined: Sat Sep 01, 2018 8:43 am
- Contact:
Re: About Question enthuware.oce-jpad.v6.2.490 :
no no man it is not https://athletesphysiques.com/dianabol-review-results/ what you think it is first name is always unique
sarms for sale
testogen gnc
sarms for sale
testogen gnc
Who is online
Users browsing this forum: No registered users and 4 guests