Answer Posted / vishnu

Here we can find out 2nd highest salary in many ways,
according to the situation we can select anyone…
1st Type:
select min(esal) from emp where esal in (select top 2 esal
from emp order by esal desc)

2nd Type:
select max(esal) from emp where esal not in(select max(esal)
from emp)

3rd Type:
select max(esal) from emp where esal <(select max(esal) from
emp )

4th Type:
select Max(esal) from EMP a where 2=(select
COUNT(distinct(esal)) from EMP b where a.eSAL<=b.eSAL);

-----------------------------------------

For 2nd Lowest Salary:

-- 1st Type:
select min(esal) from emp where esal > (select min(esal)
from emp)

-- 2nd Type:
select * from emp where esal =
(
select max(esal) from emp where esal in (select top 2 esal
from emp order by esal)
)

Explain different pipelining hazards? : Dot net architecture

1043

---

How do I know when my thread pool work item has completed?

975

---

Explain pipelining? : Dot net architecture

1054

---

what are the events for a form?

2150

---

Differnce between managed code and unmanaged code ?

1143

---

What is new in the .net 2.0 class library?

1161

---

8. Oop-Why and were we use Interfacse and Abstract class.

2188

---

I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1926

---

What are the major differences between services and web services?

972

---

Explain difference between state server and sqlserver? : .NET Architecture

994

---

Explain about .net garbage collector?

995

---

What are relation objects in dataset?

1043

---

Does .NET runtime offer Deterministic Destruction or not?

1071

---

Explain about httpruntime.cach.get(); method?

1070

---

How do I stop a thread?

1007

---