Difference between inner join and outer join?
No Answer is Posted For this Question
Be the First to Post Answer
What are the available primary index types?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
If the table does not have duplicates then which utility you can suggest to load the data ?
What is the command in bteq to check for session settings ?
what are the day to day activities of teradata DBA ?
The transaction exceeded the maximum number of rowhash locks allowed
Highlight the limitations of TPUMP Utility.
in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that
What is meant by a Least Cost Plan?
what is the difference between bpo and call centre?
we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.
5 Answers Accenture, Cognizant,
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)