shrawan kumar sahu


{ City } delhi
< Country > india
* Profession * developer
User No # 75478
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 # 8
Users Marked my Answers as Wrong # 4
Questions / { shrawan kumar sahu }
Questions Answers Category Views Company eMail




Answers / { shrawan kumar sahu }

Question { iGate, 9382 }

Can i create a lookup table without cache.


Answer

I think we can use unconnected lookup.
Correct me If i am wrong.

Is This Answer Correct ?    1 Yes 2 No

Question { TCS, 9296 }

create a mapping to retrieve the employees who are getting
salary greater than average salary?


Answer

select employee, salary from table_name
where
salary > ( select avg(salary) from table_name;

Is This Answer Correct ?    7 Yes 2 No