select empid,monthyear from empsal where sal>100000;

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 / gd

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

Answer Posted / gd

select empid,monthyear from empsal where sal>100000;

Is This Answer Correct ?

11 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a difference between complete, stop and abort?

1083

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1641

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10687

In warehouses how many schemas are there?

1073

What is Data Caches size?

1091

What is a repository manager?

1095

How can you validate all mappings in the repository simultaneously?

1371

What are session parameters ? How do you set them?

1850

What does update strategy mean, and what are the different option of it?

1092

What is sorter transformation?

1047

Explain in detail scd type 2 through mapping.

1041

What are the different versions of informatica?

1275

What is the need for an etl tool?

1068

What are the guidelines to be followed while using union transformation?

1144

What is the use of transformation?

999