Answer Posted / shivdas suryawanshi

select salary from emp where salary=(select max(salary)
from emp where salary < (selct max(salary) from emp));

What are sql commands?

1067

---

What is index example?

1049

---

How can the performance of a trigger be improved?

1090

---

Mention what is the plv (pl/vision) package offers?

1164

---

What trigger means?

1036

---

Is sql pronounced sequel or sql?

1340

---

When are we going to use truncate and delete?

1025

---

how to run 'mysql' commands from a batch file? : Sql dba

1171

---

how to enter characters as hex numbers? : Sql dba

1104

---

What is example of database?

1135

---

what is the use of friend function? : Sql dba

1063

---

Is left join and outer join same?

1118

---

What are the advantages of sql? Explain

1156

---

How do you update a sql procedure?

1092

---

Can we rollback after truncate?

1073

---