Which of the following queries will return the records for employees whose salary is exactly 62,000 OR whose name starts with the letter 'M'?

Question

Computer Science · SQL Queries

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT * FROM EMPLOYEE WHERE SALARY = 62000 OR E_NAME LIKE 'M%';

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on SQL Queries?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · SQL Queries

The 'Drain of Wealth' theory was propounded by which Indian nationalist leader?

Which event is considered the turning point in Mahatma Gandhi's leadership in the Indian independence movement?

Which African leader is known for his non-violent opposition to colonial rule?

Answer 1

SELECT * FROM EMPLOYEE WHERE SALARY = 62000 OR E_NAME LIKE '%M';

Answer 2

SELECT * FROM EMPLOYEE WHERE SALARY IN (62000, 70000) OR E_NAME = 'Mike%';

Answer 3

SELECT * FROM EMPLOYEE WHERE SALARY = 62000 OR E_NAME LIKE 'M%';

Answer 4

SELECT * FROM EMPLOYEE WHERE SALARY = 62000 AND E_NAME LIKE 'M%';

Related Practice Questions