What are the types of dbms?

0 Answers  

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

What is Referential Integrity?

3 Answers  

---

How do you write an index?

0 Answers  

---

What are the types of triggers in sql?

0 Answers  

---

what is the difference between implicit conversions and explicit conversions?

2 Answers  

---

Can we perform dml on view?

0 Answers  

---

how to drop an existing index in mysql? : Sql dba

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

Can we use having without group by in sql?

0 Answers  

---

What is Primary Key?

4 Answers   Ramco,

---

What is partition in sql query?

0 Answers  

---