SQL Server Interview Questions – HCL

SQL Server Interview Questions – HCL

1. Write a SQL query to find out the most recently hired employee in each table?table a: EMP_tableemp_iddept_idemp_nameemp_hiredateemp_reportingtotable b: dept_tabledept_iddept_name2. Explain the two methods by which SQL can be retrieved?3. Differentiate between a “where” clause and a “having” clause?4. Write a SQL statement to read data out of a table?5. Explain different types of joins?6. […]