Question

sql query for find names of employees with years of experience greater than atleast one employee in the accounts department

Comments

give your tables then ask query

---

no table bro we have to find the crt query in that 4 options.

---

Actually the question should give TABLES, otherwise we can't answer due to we don't what are the fields and how many tables are involved, In the Standard question they must provide, so don't worry on this question

just check is this correct option in that solution?

select emp_name

from Employee

where emp_year_experience > ANY ( select emp_year_experience

                                  from Employee

                                  where emp_department = " Accounts "

                                )

---

in the above question they are not asked anything about the emp-age

as per the que. we have to create two tables and later find the names of emp.

thank you!....

---

these are the options that are given in the questoin and it is  multiple choice que

 

---

@mani8466

i mistakenly used the term emp_age instead of emp_year_experience.... i will update it..

but note that ANY operator and SOME operators are equal. hence option D is right.

---

what about option B?

it is also right, but in the question they didn't specify distinct names, so i prefer option D

---

Of course option D is right bro

Wat abt the option B

I think option B is also a right option.

Because it is multiple choice type que.

Thank you.....

---

in my previous comment i discussed about option B only.. But again by mistakenly it is typed as D.... Now read it again... Moreover don't add thank you on every comment.

---

So finally option B,D are correct