Answer Posted / yuvaevergreen

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);

QUERY TO FETCH THE STUDENTS TOPPED IN ALL THE THREE SUBJECTS

SEL STUDENTID,STUDENTNAME,SUBJECT1,SUBJECT2,SUBJECT3
FROM
(
SEL STUDENTID,STUDENTNAME,SUBJECT1,SUBJECT2,SUBJECT3,
RANK () OVER (ORDER BY SUBJECT1 DESC) as SUB1RANK,
RANK () OVER (ORDER BY SUBJECT2 DESC) as SUB2RANK,
RANK () OVER (ORDER BY SUBJECT3 DESC) as SUB3RANK
FROM STUD1 QUALIFY (SUB1RANK=1 OR SUB2RANK=1 OR SUB3RANK=1 )) A

What are the various indexes in teradata? How to use them?

1018

---

Explain teradata architecture?

1098

---

Why are oltp database designs not generally a good idea for a data warehouse?

1056

---

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

1053

---

What is a node in teradata?

1002

---

What are the different table types that are supported by teradata?

1003

---

How to eliminate product joins in a teradata sql query?

1035

---

How to select first n records in teradata?

1109

---

What are types of partition primary index (ppi) in teradata?

1056

---

How to identify ppi columns?

1182

---

Why does varchar occupy 2 extra bytes?

1197

---

What do you mean by parsing?

1113

---

What are the joins in teradata and how many types of joins are there in teradata?

1008

---

What are the available primary index types?

1222

---

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

---