Answer Posted / raju

select top 1 sal from emp
where sal not in (select top 1 sal from emp order by sal
desc ) order by sal desc

What are the usages of sql?

1103

---

Do stored procedures prevent sql injection?

1015

---

What is a temporal table?

983

---

How many types of cursors are available in pl/sql?

1167

---

How do I debug a stored procedure?

1171

---

Is truncate ddl or dml?

1038

---

Sql technical questions

1337

---

What are sql ddl commands?

1138

---

Explian rowid, rownum?

1086

---

What is pl sql and why it is used for?

1158

---

What is the purpose of a secondary key?

1019

---

Explain the difference between drop and truncate commands in sql?

1114

---

What does fetching a cursor do?

1133

---

What is bulk collect in pl sql?

1158

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1497

---