Interview Questions Answers in Programming Languages AllOther, SQL PLSQL

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, 48603 }

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 { 11927 }

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