Answer Posted / satya

Hi,

Select sal from emp e where 3>=(select count (Sal)
from emp where sal>e.sal) order by sal desc;

Regards,
Satya.k

Is nosql relational?

907

---

What are aggregate functions in sql?

1117

---

How do I truncate a sql log file?

1032

---

What does the sign mean in sql?

946

---

What is left join example?

907

---

Can we write ddl statements in functions?

1074

---

What's the procedure?

888

---

How many primary keys can a table have?

972

---

how to shutdown mysql server? : Sql dba

1056

---

What are field types?

965

---

Can a varchar be a primary key?

970

---

What is sql dialect?

1066

---

explain access control lists. : Sql dba

962

---

How many triggers can be applied on a table?

899

---

What are the types of dbms?

939

---