Answer Posted / Ankur Dixit

The SELECT INTO statement in SQL is used to create a new table and insert data from the result set of a SELECT query.nnExample:nSELECT column1, column2 FROM table_name INTO new_table;

Does group by remove duplicates?

1121

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

How do I remove duplicates in two columns?

1202

---

what is sql server agent? : Sql dba

1189

---

what are aggregate and scalar functions? : Sql dba

1142

---

Do we need to rebuild index after truncate?

1155

---

What is the best sql course?

1064

---

how to start mysql server? : Sql dba

1279

---

what is dbms? : Sql dba

1070

---

what are all the common sql function? : Sql dba

1141

---

What is your daily office routine?

2353

---

what is schema? : Sql dba

1164

---

what is collation? : Sql dba

1242

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

define sql insert statement ? : Sql dba

1110

---