Answer Posted / skumar

Hi, friends This one is working fine. I have tested.

SELECT TOP 1 t.esal
from
(
select top 5 esal from employee order by esal desc
) t
order by t.esal asc

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

2065

---

how can you perform lookup range in lookup stage expalin in detail?

1942

---

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

2096

---

can we delete autodiff back up that we have set through sql server agent.

2213

---

What is ole db used for?

1021

---

How to do performance tunning a database in DB2 V8.2 UDB in linux

2271

---

What does currency type mean in database?

1205

---

How heap is implemented in database?

1180

---

how do you do sql tuning?

2107

---

What is database schema name?

1065

---

What will happen non-clustered index will be created on clustered index?

1057

---

What is a driver in database?

1166

---

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2470

---

Differentiate between extension & intension?

1436

---

What advantages does DBMS have over traditional file systems?

1046

---