How do we select distinct values from a table?

973

---

Can you explain insert, update and delete query?

1099

---

Can you explain the select into statement?

1095

---

What are the two types of indexes and explain them in detail?

991

---

What is normalization? What are different type of normalization?

1004

---

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

921

---

What are dml and ddl statements?

1040

---

What is etl process in data warehousing? What are the different stages in 'data warehousing'?

901

---

How to select the first record in a given set of rows?

969

---

What is 'cross join'? Or what is cartesian product?

925

---

What is the default '-sort' order for a sql?

951

---

What's the difference between file and database? Can files qualify as a database?

1030

---

What's difference between dbms and rdbms ?

1008

---

What is the sql 'in' clause?

1005

---

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

944

---