13 October, 2020
Tools options export/import
Use this delimiter between column click ok
Inclined to build a profession as Teradata Developer? Then here is the blog post on, explore Teradata Training
Display employee details whose dept available in dept table
Ans: Sel*From emp;
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)
Sel * from emp.e, dept.d where did = d.did
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .