In where clause u can write 254 subqueries and in from clause u can write

how many no of table can be join in a sql query.

Question Posted / jo

Answer Posted / jo

In where clause u can write 254 subqueries and in from
clause u can write n number of queries

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How is pl sql different from sql?

540

What is sql*loader?

569

How much does sql certification cost?

543

How do you delete duplicates in sql query using rowid?

533

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

575

How can we optimize a sql query?

571

What does rownum mean in sql?

551

Can you join views in sql?

538

What is a left join?

507

Can a table contain multiple primary key’s?

623

What is user in sql?

575

Define join and name different types of joins?

514

Is like operator in sql case sensitive?

505

What is the use of & in pl sql?

532

how can we optimize or increase the speed of a mysql select query? : Sql dba

504