Answer Posted / krishna kishore

select top 1 salary from emp where salary in
(select top 2 salary from emp order by salary desc)
order by salary

What is integrity in sql?

1051

---

Why cross join is used?

1083

---

What is the limitation on the block size of pl/sql?

988

---

What is pl/sql table? Why it is used?

1039

---

What is full join?

961

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1103

---

How do I find sql profiler?

946

---

What is the difference between execution of triggers and stored procedures?

1118

---

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

1136

---

What is varchar sql?

1150

---

Why do we use set serveroutput on?

969

---

what is the command line end user interface - mysql? : Sql dba

984

---

Is sql procedural language?

970

---

how to run 'mysql' commands from a batch file? : Sql dba

1121

---

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

1080

---