Answer Posted / dilip

select rank,sal from(select rownum rank,distinct(sal) from
emp order by sal desc)
where rank=2;

Can we create table inside stored procedure?

903

---

What is data type in sql?

918

---

What is sql dialect?

1035

---

Which nosql database is best?

919

---

Can a trigger call a stored procedure?

1000

---

I need a function for a train ticket reservation please answer it thanks in advance

957

---

What is the clause we need to add in function body to return variable?

965

---

Can a select statement fire a trigger?

1095

---

what is a trigger in mysql? : Sql dba

1066

---

What is difference between mysql and postgresql?

1041

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3944

---

How do I truncate a word?

990

---

What is the difference between truncate and drop statements?

1081

---

what is a stored procedure? : Sql dba

1051

---

What is union?

1080

---