ramcharantej


{ City } bangalore
< Country > india
* Profession * student
User No # 65344
Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 1
Total Views for My Questions # 4036

Users Marked my Answers as Correct # 5
Users Marked my Answers as Wrong # 3
Questions / { ramcharantej }
Questions Answers Category Views Company eMail

hi friends,can any one post the ibm mainframe inteqview questions for 1year exp candidate,for itc infotech interview?. have any body attended for this in the past?...

ITC Infotech,

1 COBOL 4036



Answers / { ramcharantej }

Question { Yardi, 320951 }

how to find the second highest salary from emp table?


Answer

select max(emp-sal) from emp
where emp-sal <(select max(emp-sal) from emp).

Is This Answer Correct ?    1 Yes 0 No

Question { Yardi, 320951 }

how to find the second highest salary from emp table?


Answer

select max(sal) from emp where empsal<(selelect max(sal)
from emp)

Is This Answer Correct ?    0 Yes 0 No


Question { DELL, 9209 }

describe 805 error


Answer

805 error means token not found.
it's nothing but inserting duplicates...

Is This Answer Correct ?    4 Yes 3 No