Answer Posted / akilis.org@hotmail.com

Let us Assume
Table Name=salary
Column Name=maxsal

select * from salary order by maxsal desc limit 2,1;

Enjoy the simple code :)

Why do you partition data?

631

---

What is #table in sql?

622

---

What does count (*) mean in sql?

1203

---

Which is the correct statement about truncate and delete?

621

---

What is a database? Explain

688

---

---

Explain what is a database?

731

---

How would you pass hints to the sql processor?

622

---

What do you mean by “trigger” in sql?

719

---

Can you call pl/sql package functions from within a fast formula?

670

---

How to display the current date in sql?

681

---

what are the types of subquery? : Sql dba

691

---

What are the advantages of normalization?

662

---

What is the difference between database trigger and stored procedure?

632

---

The select into statement is most often used to create backup copies of tables or for archiving records?

666

---

Why do we use procedures in pl sql?

618

---