Select empid,monthyear,sal from empsal where sal>100000 orderby monthy

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

Question Posted / arpan

5 Answers
9020 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / arpan

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is complex mapping?

1105

What is a surrogate key?

1061

differences between service based and product based?

1993

What are the limitations of joiner transformation?

1088

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8178

What is source qualifier transformation in informatica?

987

State the limitations where we cannot use joiner in the mapping pipeline?

1042

explan ur project architecture?

2042

Write the advantages of partitioning a session?

1257

Explain informatica architecture - version 8 / 9

1069

What are the components of Informatica? And what is the purpose of each?

1028

Define pmcmd command?

1024

What are batches?

1073

What are the types of presistent cache in look up tr.

2042

Implementation methodology

1694