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)
)

Define a managed code? : Dot net architecture

958

---

Can I customise the trace output?

1083

---

What is the mesi? : .NET Architecture

1028

---

Define cache? : Dot net architecture

959

---

How do I prevent concurrent access to my data?

1040

---

Can you explain update progress control?

945

---

What happens to the winfx technologies?

1011

---

Explain about clr?

1062

---

Explain is development of a mobile web application with asp.net is very easy? : Microsoft dot net mobile

954

---

how to set the startup position of the form?

1950

---

Explain dotnet framework ?

1046

---

What is the numeric attribute of the textbox control in .net mobile? : Microsoft dot net mobile

972

---

What is Com Callable wrapper?when it will created?

940

---

What are the different pipelining hazards and how are they eliminated? : Dot net architecture

1036

---

Different types of authentication modes in .net framework ?

1005

---