Answer Posted / gourvendra singh

In oracle you can find the 3rd max salary with the help of
the command:-

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

Does sql support programming?

1007

---

Can we join same table in sql?

961

---

How do you update sql?

912

---

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

3925

---

When sql appeared?

1023

---

what are tables and fields? : Sql dba

988

---

What is scope of pl sql developer in future?

949

---

Can 2 queries be executed simultaneously in a distributed database system?

1082

---

What is dml with example?

1011

---

List the ways to get the count of records in a table?

852

---

Where is all the data on the internet stored?

947

---

Explain what is a field in a database and record in a database?

1015

---

Why truncate is faster than delete?

1053

---

What are inner and outer joins examples of both?

879

---

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

1016

---