Answer Posted / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

What does bitemporal mean?

595

---

What does select count (*) mean in sql?

544

---

How can you tell the difference between an index and a view?

489

---

What are the advantages of sql?

557

---

What is the use of function in sql?

535

---

---

Is sql easier than java?

522

---

How do I run pl sql in sql developer?

626

---

What is a temp table?

565

---

Why schema is used in sql?

513

---

How do you optimize a stored procedure query?

563

---

Enlist some predefined exceptions?

580

---

Can we insert data into materialized view?

503

---

What is union and union all keyword in sql and what are their differences?

574

---

How can you know that statistics should be updated?

601

---

What are the commands used in sql?

523

---