Answer Posted / shaik mahamad rafi

Lets Try This

sel t.id ,t.marks,rank(t.marks) as "r" from
(

sel a.studentid,max(a.subject1) from stud1 a group by a.studentid

union

sel a.studentid,max(a.subject2) from stud1 a group by a.studentid

union

sel a.studentid,max(a.subject3) from stud1 a group by a.studentid

)as t (id,marks)

group by id qualify r=1;


CREATE TABLE STUD1
(
STUDENTID CHAR(10), STUDENTNAME CHAR(10),
SUBJECT1 INTEGER, SUBJECT2 INTEGER,
SUBJECT3 INTEGER
)PRIMARY INDEX( STUDENTID );

INSERT INTO STUD1 VALUES ('1','A1',2,7,1);
INSERT INTO STUD1 VALUES ('2','A2',1,6,2);
INSERT INTO STUD1 VALUES ('3','A3',3,5,3);
INSERT INTO STUD1 VALUES ('4','A4',4,4,7);
INSERT INTO STUD1 VALUES ('5','A5',5,3,6);

Table :

STUDENTID|STUDENTNAME|SUBJECT1|SUBJECT2|SUBJECT3
5 |A5 |5 |3 |6
3 |A3 |3 |5 |3
1 |A1 |2 |7 |1
4 |A4 |4 |4 |7
2 |A2 |1 |6 |2


O/p:

id |marks
1 |7
2 |6
3 |5
4 |7
5 |6

What is the difference between fastload and multiload? Which one is faster?

1148

---

What is a level of granularity of a fact table?

1076

---

What are the components used in smp and massively parallel processing (mpp) machines?

1004

---

Explain fallback in teradata?

986

---

Why teradata is used?

943

---

Is multi insert ansi standard?

2152

---

What happens when a node suffers a downfall?

1061

---

if collect stats but it show low confidence why?

1625

---

How is MLOAD Teradata Server restarted after execution?

1172

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2422

---

What is the use of fallback?

944

---

What are tpump utility limitations?

1066

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1904

---

What do you mean by tpt in teradata?

964

---

What is the purpose of joins in teradata and what are the available join types?

1006

---