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);

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

947

---

What is attribute indicator in pl sql?

1011

---

What are the advantages of sql?

1055

---

How is debugging done?

972

---

Is the primary key an index?

1025

---

what are the different type of sql's statements ? : Sql dba

924

---

Is pl sql a programming language?

987

---

How do I view output in sql developer?

1082

---

Which join is like an inner join?

1023

---

Define sql delete statement.

1007

---

What are the popular database management systems in the it industry?

995

---

What is data manipulation language?

1187

---

What are all the ddl commands?

1177

---

Can a composite key be null?

972

---

How do I remove sql plus from windows 10?

1096

---