Answer Posted / nitin

select max(salary) from emp where salary<>(select
max(salary) from emp);

What do you mean by query optimization?

1051

---

What's the difference between a primary key and a clustered index?

1028

---

How subquery works in sql?

1131

---

What is view? Can we update view

1523

---

what's the difference between a primary key and a unique key? : Sql dba

1112

---

what is subquery? : Sql dba

1190

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1105

---

What does pl sql stand for?

1156

---

What is right join sql?

1013

---

What is pl sql in dbms?

992

---

What are the benefits of pl sql?

1182

---

Can we rollback truncate?

1052

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

1019

---

what are local and global variables and their differences? : Sql dba

1139

---

what is a cursor? : Sql dba

1066

---