Answer Posted / kirankumar.vangeti

delete from emp
where rowid not in (select max(rowid)
from emp
group by emp_number);

How many types of primary keys are there?

980

---

Explain the significance of the & and && operators in pl sql.

952

---

Can you skip header records while loading? : aql loader

976

---

What is sqlservr exe?

943

---

What is sql stand for?

947

---

How does join work in sql?

962

---

What is not equal in sql?

1012

---

How to run sql*plus commands in sql developer?

1086

---

What is the current version of sql?

974

---

What is oracle and pl sql?

1081

---

what is oltp (online transaction processing)? : Sql dba

1016

---

What is the command used to fetch first 5 characters of the string?

1336

---

What is synchronized subquery?

1094

---

Write a query to display the current date in sql?

969

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

990

---