Answer Posted / selvaraj anna university coe

SQL> SELECT 1,emp_no,emp_name FROM emp;

1 EMP_NO EMP_NAME
--------- --------- -------------------------
1 100 SELVA
1 101 RAJ
1 102 A S KALA
1 103 JESLIN FANTA MALAR
1 104 ANITA
1 105 MURUGU
1 106 SRIVATSAN
1 107 SARABOOT
1 108 KARTHI SIR
1 109 SUDHA
1 110 MERCHI
1 111 SAVI

12 rows selected.

When is the update_statistics command used?

1112

---

What are views in sql?

979

---

Which command is used to delete a package?

1163

---

What is the difference between having clause and where clause?

1057

---

Where the sql database files are stored?

1014

---

How can we link a sql database to an existing android app?

1022

---

Can we join same table in sql?

1016

---

How to use transactions efficiently : transact sql

1054

---

What are the triggers associated with image items?

1041

---

How delete a row in sql?

992

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1043

---

What is function and procedure in pl sql?

1039

---

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1163

---

what is the difference between union and union all? : Sql dba

1017

---

Can two tables have same primary key?

971

---