Answer Posted / girija.112

ANS:

SELECT department_id,COUNT(department_id) AS "Occurrences"
FROM departments
GROUP BY department_id
HAVING ( COUNT(department_id) > 1 )

DEPARTMENT_ID Occurrences
------------- -----------
80 2
60 3

--In my 'departments' table , i have not assigned department_id column as a "primary key / unique key"

how to use like conditions? : Sql dba

1119

---

What is difference between pl and sql?

1071

---

what is auto increment? : Sql dba

1018

---

In a distributed database system, can we execute two queries simultaneously?

1100

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031

---

What is the basic form of sql query?

950

---

how to start mysql server? : Sql dba

1210

---

How do I delete a trigger?

969

---

What is a dynamic query?

1031

---

What is a join query?

971

---

What are types of exception?

924

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2116

---

Is primary key an index?

1000

---

What is database migration?

974

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1046

---