Answer / Rajnish Kumar Shriwastawa

SQL allows you to perform calculations using functions and operators. You can use arithmetic operators (+, -, *, /) for basic calculations, and mathematical functions like SUM(), AVG(), MAX(), MIN(), COUNT(), and others for more complex calculations. For example, to calculate the average salary of employees from the 'employees' table, you can use: SELECT AVG(salary) FROM employees;

how to use myisamchk to check or repair myisam tables? : Sql dba

1 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

what is “go” in t-sql? : Transact sql

1 Answers  

---

when normalization is required

3 Answers   HCL,

---

counting the no.of characters occurs in a string by using pl/sql function

1 Answers   TCS,

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1 Answers  

---

What is right join in sql?

1 Answers  

---

What is consistency?

1 Answers  

---

How do you truncate?

1 Answers  

---

how to load data files into tables with 'mysqlimport'? : Sql dba

1 Answers  

---

What is the difference between left outer join and left join?

1 Answers  

---