SQL Interview Question - AL1

  1.  Find the duplicate records
  2. Delete the duplicate records
  3. Find department-wise average, max, min salary
  4. Find the emp name from 3rd character
  5. Find employee name starts/ ends/ anywhere in the name is R
  6. Find the alternate records
  7. Difference between Delete, Truncate, and Drop
  8. Find the employee name with manager name
  9. Find the students details who have not won any prize
  10. What are the SQL constraints
  11. Write SQL query to find the random employee details
  12. Find the second highest/ fifth highest salary of the employee
  13. Find the employee details who joined in month of Feb in any year
  14. Find the employee details who joined in month of Feb in specific year
  15. Find the employee details who joined between specific date to specific date 
  16. Find the employee details who joined between specific month to specific month
  17. Find the employee details who joined between specific year to specific year
  18. Find total employee count who are working in specific department
  19. Find total employee count who are working in specific department and their location is specific
  20. Find total employee count who are working in specific department and their location is not specific
  21. Update employees gender -male to female and female to male
  22. What is view table
  23. What is composite primary key
  24. Write SQL query to show first name and last name together in one column
  25. What is difference between char and varchar
  26. Find Customers Who Purchased Exactly Two Different Products in a Single Month
  27. Identify Customers Who Haven’t Made Any Purchase in the Last 6 Months
  28. Identify Users Who Made Their First Purchase During a Promotional Campaign
  29. Find the total employee count without using COUNT function
  30. Write a query to find the total quantity of products purchased by each customer
  31. Display the total sales amount (Quantity * PricePerUnit) per customer.
  32. Find the average sales amount per product category.
  33. Customers with Total Sales Greater Than ₹50,000
  34. Identify the product that has been sold the most in terms of total quantity.