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 are aggregate and scalar functions? : Sql dba

1104

---

How many sql are there?

1047

---

What is dense_rank in sql?

1034

---

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2203

---

What is structural independence and why is it important?

1071

---

What is t sql used for?

1057

---

How does cross join work?

1006

---

How to return multiple rows from the stored procedure?

1012

---

How many types of primary keys are there?

1078

---

How to create an array in pl/sql?

1115

---

what is a primary key? : Sql dba

1085

---

What is the file extension for sql database?

1061

---

How do I view tables in mysql?

1027

---

What is date functions?

1088

---

What is snowflake sql?

1124

---