sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---

How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????

3 Answers   Mphasis,

---

How many types of joins are there in teradata?

0 Answers  

---

How does indexing improve query performance?

4 Answers   Satyam,

---

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

---

---

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

Explain the meaning of Amp?

0 Answers  

---

If RDBMS is halted what will you do ?

0 Answers   Teradata,

---

can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,

---

What is SQL Assistence?please eample

4 Answers   IBM,

---

How do you Generate sequence at the time of Display?

2 Answers   Infosys,

---