How do you write a complex sql query?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What is difference between hql and sql?

0 Answers  


When are we going to use truncate and delete?

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,


how is exception handling handled in mysql? : Sql dba

0 Answers  


What do you mean by table in sql?

0 Answers  






What is bulk collections?

2 Answers  


Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  


What are the pre requisites?

1 Answers  


How sql query is executed?

0 Answers  


what is explain plan?

4 Answers  


What is compute?

0 Answers  


What is function and procedure in pl sql?

0 Answers  


Categories