Answer Posted / swapnareddy

select sal from emp a where 3>(select
count(distinct(sal))from emp b where a.sal<b.sal);

What is a sql statement?

1019

---

what is clause? : Sql dba

1118

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

1644

---

What is pl sql block structure?

1095

---

Which is better join or subquery?

1192

---

What is the best partition size for windows 10?

1050

---

Explain the difference in execution of triggers and stored procedures?

1065

---

How do I remove duplicates in two columns?

1150

---

What is scope and visibility in PL/SQL?

1291

---

What is on delete set null?

1137

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1080

---

What is rename in sql?

1019

---

What is the starting oracle error number?

1100

---

Is it possible to read/write files to-and-from PL/SQL?

1151

---

How do you delete a table?

1124

---