Sign Up Login


adil


{ City } thiruanantapuram
< Country > india
* Profession * se
User No # 78833
Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 1
Users Marked my Answers as Wrong # 0
Questions / { adil }
Questions Answers Category Views Company eMail




Answers / { adil }

Question { HCL, 44792 }

How to swap values between two variables without using a
third variable?


Answer

string a = "adil ahmad", b = "anuj gupta";
a = a + b;
b = a.Substring(0, a.Length - b.Length);
a = a.Substring(b.Length, a.Length - b.Length)

Is This Answer Correct ?    0 Yes 0 No

Question { 10613 }

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example
empno ename mgr_id
1 john 3
2 paul 3
3 smith 1
4 kevin 1
5 stewart 2

result has to look like this

ename manager
john smith
paul smith
smith john
kevin john
stewart paul


can u plz help me out in this.....


Answer

I think this one will work
Select a.ename as Employee ,b.ename as Manager from
EMP ,EMP B
where
A.MGR_ID=B.empno

Is This Answer Correct ?    1 Yes 0 No