Query on Employee

Question

Hi all i have one query with union select name from employee_1 Union select name from employee_2  here i want to display all employee results  if i have an employee with name ='ganesh'  if there is no such employee with name='ganesh' then dont return any result from query pls help me on this

Dharmraj Thakur · Answer

Its done.... ;with emps(name) AS ( select name from employee_1 UNION select name from employee_2 ) select name from emps where (select count(name) as count from emps where name = 'ganesh') > 0

Amit Gupta · Answer

Can you show some sample data with expected outputso that we know what exactly you want to achieve.

Vishwas Kadamannaya · Answer

I want to display all employees  not only ganesh

Amit Gupta · Answer

Use where clause in your query select name from employee_1 where name= 'ganesh' Union select name from employee_2 where name= 'ganesh'