Answer Posted / gaurav singh 'viccky'

select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))

What is a left join?

954

---

Explain the savepoint statement.

1099

---

Can a composite key be null?

978

---

What is the maximum size of sqlite database?

1112

---

What is type and rowtype in pl sql?

1016

---

Is sql harder than python?

1108

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1002

---

what is the difference between a web-garden and a web-farm? : Sql dba

1081

---

What is the use of pl/sql table?

1067

---

Explain correlated query work?

1056

---

what is the difference between undefined value and null value? : Sql dba

1101

---

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209

---

Do foreign keys improve performance?

1026

---

Can we join two tables without common column?

1005

---

How to load data with sql*loader?

1051

---