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 are the available primary index types?

1275

---

What are the multiload utility limitations?

1112

---

If RDBMS is halted what will you do ?

2220

---

How to run a query in teradata?

1144

---

What is real time and near real time data warehousing?

1160

---

What is basic teradata query language?

1163

---

Different phases of multiload?

1063

---

Can we collect statistics on table level?

1092

---

Differentiate database data and data warehouse data?

1162

---

What are the different methods ot loading a dimension table? A fact table etc?

1082

---

What is the difference between global temporary tables and volatile temporary tables?

1238

---

What are the uses of bynets in multi-node systems?

1071

---

What is spool space? Why do you get spool space errors?

1079

---

What is a three-tier data warehouse?

1152

---

How many codd's rules are satisfied by teradata database?

1149

---