Answer Posted / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

when MSQL8.0 is in market

1608

---

what is the difference between char_length and length? : Sql dba

582

---

what are string data types? : Sql dba

522

---

how to use in conditions? : Sql dba

520

---

What are inner and outer joins examples of both?

503

---

---

What is t sql in sql server?

575

---

What are the most important ddl statements in sql?

590

---

define sql insert statement ? : Sql dba

561

---

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

566

---

How global cursor can be declare with dynamic trigger ?

1761

---

Is pl sql better than sql?

564

---

How do you modify a column in sql?

544

---

What pl/sql package consists of?

650

---

What will you get by the cursor attribute sql%notfound?

601

---

How do I run a sql script?

526

---