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
8878 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 the difference is between a database, a data warehouse and a data mart?

1086

what is the difference between informatica6.1 and infomatica7.1

2188

Mention some types of transformation?

999

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1005

Is it possible to define a single node as a Gateway node as well as worker node?

1062

What is the benefit of partitioning a session?

1107

Explain pushdown optimization and types in informatica

1020

What are connected or unconnected transformations?

1053

What is native users?

1102

What are mapplets?

1218

What are the tasks that source qualifier perform?

1038

Explain the etl program with few examples.

970

What is olap (on-line analytical processing?

1011

tell me about your project functionality

2298

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1446