Interested to Buy Any Domain ? << Click Here >> for more details...
following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal
empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000
- 5 Answers
- 9028 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gd
select empid,monthyear from empsal where sal>100000;
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / sweta kedia
Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sateesh
select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / animesh
Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000
| Is This Answer Correct ? | 2 Yes | 8 No |
can you use flat file for repository?why?
how can u approach u r client
How do you create single lookup transformation using multiple tables?
How to update records in Target, without using Update Strategy?
Tell me about Propagate functions in informatica
What are the types of maping in Getting Started Wizard?
What are the different tools in workflow manager?
how will you remove the duplicate records from flat file without using sorter?
How to prepared lld.can any one tell me detailed explanetion.
When the informatica server marks that a batch is failed?
How you can differentiate between connected lookup and unconnected lookup?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
Teradata 
