Learn PHP

Search This Blog

Write a Query to get employee name id manager name using self join

Posted by Unknown on June 03, 2014

Get link
Facebook
X
Pinterest
Email
Other Apps

select a.id,a.name as employee,b.name as manager from empmgr a,empmgr b where a.mgr=b.id

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Basic of AnjularJs | AngularJs with Examples | One way-data

one way Data Binding in AngularJS FirstName :{{fname}} MiddleName : FirstName :{{fname}} MiddleName :

All Mysql JOIN with example.

Note: FULL JOIN doesn't support to Mysql so we can use UNION or UNION ALL select ed.empid, ed.emp_name, ed.emp_Join, edesg.designation from emp_data ed FULL JOIN emp_dseg edesg ON ed.empid = edesg.empid; mysql> select * from emp_data; +-------+------------+------------+ | empid | emp_name | emp_Join | +-------+------------+------------+ | 1 | Ajay | 2015-01-11 | | 2 | Anji | 2015-01-05 | | 3 | Sabhapathi | 2015-11-11 | | 4 | Bhasker | 2015-04-11 | | 5 | Raju | 2014-01-10 | | 6 | Mahipal | 2015-01-15 | | 7 | Manoj | 2015-09-14 | | 8 | Ragvendra | 2015-06-05 | | 9 | Sundheer | 2015-01-09 | | 10 | Mahi | 2015-01-1 | | 11 | Vijay | 2015-01-05 | | 12 | Sandip | 2015-01-1 | +-------+------------+------------+ 12 rows in set (0.00 sec) mysql> select * from emp_dseg; +-------+----------------------+ | empid | designation | +-------+----------------------+ | 1 | Dev ...

Powered by Blogger

All rights resever for http://learnphp4mmanoj.blogspot.com

Write a Query to get employee name id manager name using self join

Comments

Post a Comment