Answer Posted / ankur akash

A query inside a query is a sub query.
The first query depends for its execution based on the
result provided by the execution of inside query. i.e. subquery.
For ex.
Select last_name, salary, job_id
from employees
where salary >(select last_name, salary
from employees
where last_name = 'Higgins');

Here
Select last_name, salary, job_id
from employees
where salary >
talks about the first query depending for its result based
on the execution of the inner query i.e. sub query
(select last_name, salary
from employees
where last_name = 'Higgins');

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

575

---

What is rtm in testing?

572

---

what's the difference between a primary key and a unique key? : Sql dba

504

---

How many sql statements are used? Define them.

573

---

Do foreign keys improve performance?

543

---

---

what is myisam? : Sql dba

574

---

When do we use triggers?

583

---

Is pl sql and postgresql same?

567

---

What is where clause in sql?

530

---

how can you see all indexes defined for a table? : Sql dba

537

---

what are date and time data types? : Sql dba

534

---

Are pl sql variables case sensitive?

590

---

Is sql a microsoft product?

496

---

What is sqlca in db2?

533

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1523

---