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 enhanced features in teradata v2r5 and v2r6?

1138

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1114

---

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1104

---

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1169

---

Did you write stored procedures in teradata?

1134

---

What is meant by a dispatcher?

1022

---

What is collect statistics?

1004

---

What are the functions involved in shared information architecture?

1074

---

What is a dimension table?

1066

---

What is bteq utility in teradata?

981

---

How do you set the session mode parameters in bteq?

1108

---

Steps to create a data model?

1140

---

How to select first n records in teradata?

1109

---

Explain the term 'tables' related to relational database management system?

1055

---

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

2049

---