Answer Posted / chandrakant agrawal

Let us try one using :

select distinct dept_name
from departments;

What this query would return if dept_name column contains
NULL values.

What is inner join in sql?

1085

---

what does the t-sql command ident_current does? : Transact sql

985

---

Explain what is dbms?

1071

---

What type of database is sql?

1029

---

What is difference between pls_integer and integer?

968

---

What is meant by <> in sql?

982

---

How to add, remove, modify users using sql?

1039

---

How many types of index are there?

1044

---

What trigger means?

993

---

How to return multiple rows from the stored procedure?

971

---

How can I speed up sql query?

966

---

what is the difference between inner and outer join? Explain with example. : Sql dba

1031

---

how to check myisam tables for errors? : Sql dba

1322

---

What is an implicit commit?

1058

---

What is auto increment feature in sql?

1127

---