Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
No Answer is Posted For this Question
Be the First to Post Answer
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
Why FLOAD does not support multiset tables??
Explain vproc in teradata?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
How is MLOAD Teradata Server restarted after execution?
What is the difference between SI and JI?
What are the joins in teradata and how many types of joins are there in teradata?
How many types of joins are there in teradata?
What are the design features involved in teradata?
Can we collect statistics on table level?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?