Answer Posted / sankar

select * from emp where sal=(select max(sal) from emp where
sal not in(select max(sal) from emp))

What is sql prepared statement?

976

---

Why commit is not used in triggers?

1038

---

How to create an array in pl/sql?

1062

---

What is the maximum number of triggers, you can apply on a single table?

991

---

How do I order by ascending in sql?

1010

---

What are literals in sql server?

1161

---

How does an execution block start and end in pl sql?

950

---

What is thread join () in threading?

1005

---

What is the difference between unique and primary key constraints?

1068

---

What do you mean by table in sql?

986

---

How to rename a column in the output of sql query?

1071

---

Which join is like an inner join?

1021

---

What is sqlite used for?

989

---

When is the update_statistics command used?

1111

---

What are the two virtual tables available at the time of database trigger execution?

1220

---