Which of the following is correct SQL query to get records of clerks from EMP table?

ایم پی ٹیبل سے کلرکوں کے ریکارڈ حاصل کرنے کے لئے مندرجہ ذیل میں سے کون سا صحیح ایس کیو ایل استفسار ہے؟

SELECT * FROM EMP WHERE Job = 'Clerk';

SELECT * FROM EMP WHERE Job == 'Clerk';

SELECT ALL FROM EMP WHERE Job = 'Clerk';

None of these

The single equals sign = is used for comparison in SQL conditions.

The query correctly filters rows where the Job column matches the string 'Clerk'.