Query Importing and Exporting in TeraData

 

Query man TD12/SQLA TD13 Importing and exporting

Tools   options  export/import

Use this delimiter between column     click ok  

Exporting Step

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

Importing Steps

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

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

Simple subquery

Display 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)

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

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

Display 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

   

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

EID	EN	DID
1	A	20
2	B	30
3	C	40

Emp   Dept

DidD                                                             Did	Dcat	DLOC
10	IT
20	HR
30	Sales

 Emp –address

EDI	Address
1	HYD
2	MUM

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

For an in-depth knowledge, click on below

• Teradata Interview Questions
• Working with Project sessions in TeraData