Answer Posted / shivdas suryawanshi

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

Is pl sql still used?

977

---

Can we use ddl statements in stored procedure?

1154

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1133

---

Explain two easy sql optimizations.

1013

---

How many tables can you join in sql?

957

---

What does (+) mean in sql joins?

1066

---

What is the use of stored procedures?

1053

---

What is data definition language?

1092

---

What are pl/sql cursor exceptions?

1106

---

What is sqlite used for?

1002

---

how to check myisam tables for errors? : Sql dba

1321

---

How do I find duplicates in sql?

929

---

Is natural join same as inner join?

943

---

What is sql entity?

1107

---

describe transaction-safe table types in mysql : sql dba

1006

---