Can we create clustered index without primary key?

0 Answers  

---

Is sql a backend?

0 Answers  

---

How run sql*plus commands that are stored in a local file?

0 Answers  

---

Write a query to find second highest salary of an employee.

27 Answers  

---

how to find the second highest salary from emp table?

211 Answers   CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

---

how to calculate the difference between two dates? : Sql dba

0 Answers  

---

Is delete faster than truncate?

0 Answers  

---

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

---

What sql does db2 use?

0 Answers  

---

What is an example of translating a date into julian format?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

What is foreign key sql?

0 Answers  

---