mobileNavlogo
headerlogo

Query Importing and Exporting in TeraData

13 October, 2020

Ratings

Related Blogs

 

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)    

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

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .