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