Answer / senthil

select max(sal) from emp where sal <(select max(sal) from emp)

Answer / srinivas

select * from emp m where(select count(distinct sal)+1 from emp s where s.sal>m.sal)=2

Answer / saiz

select min(salary)
from emp
where salary in ( select top 2 salary
from emp
order by salary desc);

What is the difference between SQL table and the PLSQL table?

3 Answers   Mastek,

---

a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

0 Answers   TCS,

---

What is identity column in sql server?

0 Answers  

---

What is cross join example?

0 Answers  

---

What is the max nvarchar size?

0 Answers  

---

---

Where can I learn sql for free?

0 Answers  

---

ex: take one schema in that t1,t2,.....tn tables and you don't no the table name also. write a procedure if enter columns name then display the maching columns .otherwise display the unmatch columns.

1 Answers   Zensar,

---

What are string functions in sql?

0 Answers  

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

What is number function in sql?

0 Answers  

---

What are predefined functions in sql?

0 Answers  

---

How do you drop a trigger?

0 Answers  

---