Answer Posted / thiyagarajan

select table1.columnname1,table2.columnname2
from
table1 full outer join table2
on
table1.colname=table2.colname

What is plpgsql language?

1140

---

What are the two types of periodical indexes?

987

---

How do you exit in sql?

1157

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2163

---

List and explain the different types of join clauses supported in ansi-standard sql?

1400

---

What is trigger with example?

1167

---

what is primary key? : Sql dba

1076

---

Define sql delete statement.

1063

---

What is pls_integer in pl sql?

1156

---

What is data control language (dcl)?

1203

---

What is sql architecture?

1102

---

What is meant by <> in sql?

1026

---

What is the use of <> sql?

1036

---

What are the 3 modes of parameter?

1203

---

Is sql injection illegal?

1079

---