Answer Posted / kaushal kassi

select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)

What is primary key secondary key alternate key candidate key?

1017

---

How do I count rows in sql query?

974

---

Can we commit in trigger?

952

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4001

---

How insert into statements in sql?

1057

---

Explain the advantages and disadvantages of stored procedure?

1133

---

i have some prob lem to tell me about my self in interview first round ...

2151

---

What is trigger and types?

1002

---

What is type and rowtype in pl sql?

1008

---

Explain clause in sql?

1008

---

What is an emotional trigger?

985

---

What is sql integrity?

1135

---

When to use inner join and left join?

938

---

How do you optimize a query?

976

---

What is pl sql quora?

1126

---