Blog
Query Importing and Exporting in TeraData
13 October, 2020
Related Blogs
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