Answer Posted / dinesh rajput

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

How would you convert date into julian date format?

1001

---

what are the differences between binary and varbinary? : Sql dba

1038

---

What are all different types of collation sensitivity?

1029

---

What does pl sql stand for?

1109

---

what are the type of locks ? : Sql dba

962

---

Explain polymorphism in pl/sql.

1113

---

Why truncate is used in sql?

1003

---

Where not exists in sql?

976

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

955

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1118

---

How does cross join work?

948

---

What is java sql drivermanager?

1086

---

what are all the different normalizations? : Sql dba

1036

---

Why is nosql good?

1023

---

Difference between truncate, delete and drop commands?

1082

---