Answer Posted / nitin

SQL> select emp_sal from (select emp_sal from nitin order
by emp_sal desc) group by rownum,emp_sal
having rownum=2;

What is the difference between having clause and where clause?

1062

---

what are the 'mysql' command line options? : Sql dba

1073

---

Is merge a dml statement?

980

---

Can we write ddl statements in functions?

1117

---

What is the purpose of the partition table?

1049

---

What is insert command in sql?

1131

---

How can we implement rollback or commit statement in a trigger?

1039

---

How many commands are in sql?

1073

---

What is trigger types of trigger?

1070

---

Can you skip header records while loading? : aql loader

1053

---

What is a recursive stored procedure?

1185

---

List out the acid properties and explain?

953

---

Is sql similar to python?

977

---

What are the three pl sql block types?

1009

---

Can we create view in stored procedure?

973

---