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.

How many row comparison operators are used while working with a subquery?

543

---

Is sql microsoft?

551

---

what is union, minus and interact commands? : Sql dba

669

---

How do I count rows in sql?

562

---

What is an ndf file?

534

---

---

What is the difference between jpql and sql?

555

---

What do you mean by “trigger” in sql?

626

---

Why do we create stored procedures & functions in pl/sql and how are they different?

507

---

How bulk collect improves performance?

575

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

528

---

Can we rename a column in the output of sql query?

545

---

Show code of a cursor for loop.

585

---

how to use case expression? : Sql dba

557

---

What does truncate mean in sql?

538

---

Is inner join same as self join?

587

---