Answer Posted / akula

select min(sal) from(select distinct(sal) from emp order by sal desc) where rownum<=3;

Is nosql relational?

948

---

What do you understand by case manipulation functions?

1041

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3577

---

What is pl sql block in dbms?

1011

---

what is the syntax used for partition in tsql? : Transact sql

1024

---

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1013

---

Explain what is a column in a table?

1117

---

How do I view a sql database?

1023

---

What types of commands can be executed in sql*plus?

1116

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1442

---

Explain the uses of control file.

1053

---

what is msql? : Sql dba

994

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4028

---

Difference between truncate, delete and drop commands?

1091

---

How do you create a db file?

1020

---