Query man TD12/SQLA TD13 Importing and exporting

Tools  2 options  2export/import

Use this delimiter between column   2  click ok  

Exporting Step

  • Open query man
  • File menu2 export results
  • Select the query press’f5’
  • File name 3the exportàsave

Importing Steps

  • Delete the Header for the input file
  • File 2INPUT DATA
  • Insert into emp(????)
  • Specified the file  2 Click open

Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training

Simple subquery

2Display employee details whose dept available in dept table

Ans: Sel*From emp;

Sel*From Dept;

Sel*From emp-Address; Select* emp where deptid in(Select deptid From Dept)

2Display Dept‘s name which does not have an employee?

Ans: Sel*From Dept  where deptid not in(Select deptid From Dept)

2Display Top 3 salary condate sub-Quer;

Ans: Select district (a. party income) From party a where3>( salary count(district(b. party income) ) From party b where a. party income< b. party income)  

Note: for nth max salary Top n salaries we have to go for either of the below wants

  OLAP function  

Note Sub Query always return first Query column only(outer Query any)    

EIDENDID
1A20
2B30
3C40

Emp   Dept

DidD                                                             DidDcatDLOC
10IT 
20HR 
30Sales 

 Emp –address

EDIAddress
1HYD
2MUM

  Sel * from emp.e, dept.d where did = d.did

For an in-depth knowledge, click on below