IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN
ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES
HOW?PLZ GIVE ME A EXAMPLE.
Answers were Sorted based on User's Feedback
Answer / oceanblue
Yes, you can have a column for Primary key and have another
column which will have no duplicates or null.
A Salary Table will have employee ID as primary key. The
table also contains TAX-ID which can not be null or duplicate.
|Is This Answer Correct ?||7 Yes||0 No|
Answer / rajiv senapati
|Is This Answer Correct ?||2 Yes||0 No|
any one pls tell me what are the table names in banking project?
What is differnce between Error code and Error Level in Bteq
what is sysdba and sysdbc ? which has high priority ?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: email@example.com
Difference between Qualify and group
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
what happen if a query fail in dispatcher?
Can we load a Multi set table using MLOAD?
I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?