Make sure those queries are work in SQL Server

Q-25. Write An SQL Query To Fetch Duplicate Records Having Matching Data In Some Fields Of A Table. Ans.

The required query is:

SELECT WORKER_TITLE, AFFECTED_FROM, COUNT FROM Title GROUP BY WORKER_TITLE, AFFECTED_FROM HAVING COUNT > 1; Q-26. Write An SQL Query To Show Only Odd Rows From A Table. Ans.

The required query is:

SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) <> 0;

Q-27. Write An SQL Query To Show Only Even Rows From A Table. Ans.

The required query is:

SELECT * FROM Worker WHERE MOD (WORKER_ID, 2) = 0;