Group Discounts available for 3+ students and Corporate Clients

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

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Query Importing and Exporting in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6