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 many rows can sqlite handle?

1043

How to run pl/sql statements in sql*plus?

1016

Can we use update in sql function?

1003

What are the string functions in sql?

922

What is pl sql quora?

1068

What are tuples in sql?

1056

What is bitemporal narrowing?

1229

Can we insert data into view?

844

What are the types of views in sql?

1036

what is a control file ? : Sql dba

984

Can we use views in stored procedure?

966

What is an exception in PL/SQL? What are the two types of exceptions?

1187

How do you drop a trigger?

922

Explain the purpose of %type and %rowtype data types with the example?

924

Is left join faster than join?

982