Query Importing and Exporting in TeraData

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

Simple sub query

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

Emp

Dept

Emp –address

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