Answer Posted / sri

without using "avg" we can find the avg salary by using sum
(sal)/count(sal);

sel sum(sal)/count(sal) as avgsal from tablename

regards,
sri

how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1684

---

What is the use of fallback?

963

---

How to Extract data from multiple legacy systems?

1066

---

How to select first n records in teradata?

1068

---

Write a program to show the parser component used in teradata?

954

---

What is the meaning of Caching in Teradata?

1102

---

What is the use of virtual processor connectivity in teradata?

964

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

961

---

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

786

---

What is meant by a Virtual Disk?

1076

---

What is a node in teradata? Explain

957

---

What is the purpose of joins in teradata?

1099

---

how do you manage the production space. what are the proactive methods you can take ?

1903

---

What are the different table types supported by teradata?

914

---

What is the purpose of using case expression in teradata?

976

---