Answer: This is a simple question with one trick. The trick here is to use Group by on two columns Name and Email. Query would be as follows: SELECT name, email, COUNT () FROM Employee. GROUP BY name, email. HAVING. COUNT () > 1. Write a SQL query to find records in Table A that are not in Table B without using NOT IN operator. This example shows two columns selected from the “student” table, and two calculated columns. The first of the calculated columns is a meaningless number, and the other is the system date. select studentID, FullName, sat_score, recordUpdated, 3+2 as five, now () as currentDate from student;. Write a query to get the current date List department who has more than 4 employee born after 1960: 2 ,count (*) "NEW EMPLOYEES" ,count (*) "NEW EMPLOYEES". The number of columns must be the same as the number of columns defined in the CTE_definition Display the business entity ID number, the login ID, and the title for each one Label the. This code first selects some columns from the tables employee and department. To use NTH_VALUE (), we have to specify the column and the value of N. Since we want to get the third-highest salary, the column is salary, and N = 3; hence, we have NTH_VALUE (salary, 3). This will get us the third-highest salary. SQL>select dname,count(ename) from emp,dept where emp.deptno=dept.deptno group by dname; ... Display employee name,job,depart name ,manager name,his grade and make out an under department wise? ... Display the names of the employees from department number 10 with salary greater than that of all employee working in other departments.