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

Where is all the data on the internet stored?

1025

Why do we need pl sql?

985

What is bind reference and how can it be created?

1026

What is cursor in pl sql?

1122

Why do we create views in sql?

1159

What is normalization? How many normalization forms are there?

1092

How to process query result in pl/sql?

1139

Can we rollback truncate?

1007

Which is faster count (*) or count 1?

1041

What are the two types of exceptions in pl/sql?

1059

How do I view output in sql developer?

1089

What is pl sql architecture?

968

What is string data type in sql?

1151

Can I create table without primary key?

1004

what are different types of keys in sql?

1162