Answer / gd

select empid,monthyear from empsal where sal>100000;

Answer / arpan

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

Answer / sweta kedia

Select EMPID from EMPSAL Where MONTHYEAR IN(SELECT monthyear
from empsal
Group By monthyear
where
sal> 100000)

Answer / sateesh

select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.

Answer / animesh

Select EMPID from EMPSAl
Group By monthyear
where
sal> 100000

how to work with mapplet designer in informatica?

7 Answers  

What is workflow? What are the components of the workflow manager?

0 Answers  

What is the difference between view and materialised view?

4 Answers  

how can we run workflow with pmcmd?

3 Answers   Wipro,

Difference between task flow and linear task flow

0 Answers  

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

Implementation methodology

0 Answers  

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

What is A complex mapping?

3 Answers   TCS,

Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.

7 Answers   Cognizant, Wipro,

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,