Answer Posted / udayalakshmij

select emp_name,max(salary) from emp except(select max(salary) from emp);

What is union and union all keyword in sql and what are their differences?

1108

---

How to raise user-defined exception with custom sqlerrm ?

1131

---

List and explain the different types of join clauses supported in ansi-standard sql?

1356

---

How can you create an empty table from an existing table?

1083

---

Can you have a foreign key without a primary key?

955

---

What is an implicit commit?

1058

---

Which is faster truncate or drop?

1045

---

What is mutating sql table?

1116

---

Is sql a dbms?

1017

---

explain the difference between delete , truncate and drop commands? : Sql dba

1096

---

What is meant by <> in sql?

981

---

What normalization means?

982

---

Why query optimization is needed?

930

---

What is trigger and types?

1030

---

Why schema is used in sql?

1052

---