difference between two codes
Hi, why does the first code work too, but gives me a different outcome? thanks...
Thanks for reaching out.
Both codes work because they have correct syntax. The difference is because in the second one you have a filter -the WHERE clause. The first one does not have a filter. This condition in the COUNT() function is neglected by the Workbench. These codes are the same:
Hope this helps.