Query Importing and Exporting in TeraData

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 f or input file
  • File 2INPUT DATA
  • Insert into emp(????)
  • Specified the file  2 Click open

 

Simple sub query

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 any 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

 

Screenshot_8

 

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