Home / MCQ Bank / Computer

Computer MySQL Difficulty: Medium

What is the significance of the statement "HAVING COUNT (emp_id)>2" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name HAVING COUNT (emp_id)>2

Select the correct option to test your answer:

More Computer Questions

When the pointer is NULL, then the function realloc is equivalent to the function . . . . . . . . What will be the output of the following C code? #include <stdio.h> void main() { int i = 2; do { printf("Hi"); } while (i < 2) } Which of the following is correct about friend functions? What is the value of the following expression? 2+4.00, 2**4.0 What will be the output of the following Java program, if we run as "java main_arguments 1 2 3"? class main_arguments { public static void main(String [] args) { String [][] argument = new String[2][2]; int x; argument[0] = args; x = argument[0].length; for (int y = 0; y < x; y++) System.out.print(" " + argument[0][y]); } }