Answer Posted / radha sri seshu

second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);

How do you modify a table in sql?

1124

---

What is difference between stored procedures and application procedures?

1013

---

What is fmtonly in sql?

1085

---

What is sql deadlock?

1142

---

describe mysql connection using mysql binary. : Sql dba

1066

---

What is the difference between syntax error and runtime error?

1140

---

What is a common use of group by in sql?

1051

---

What's the difference between a primary key and a clustered index?

986

---

What are the types of dbms?

974

---

How much does sql certification cost?

1089

---

What is a memo field?

969

---

What schema means?

888

---

State some properties of relational databases?

1057

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

960

---

Mention what are different methods to trace the pl/sql code?

1205

---