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

Why do we use sql constraints? Which constraints we can use while creating database in sql?

982

Does sql profiler affect performance?

950

What is a natural join?

1005

What sql does db2 use?

934

What is number function in sql?

921

Can we use distinct and group by together?

1003

Can variables be used in sql statements?

984

What is vector point function?

1007

What are basic techniques of indexing?

1332

How do I run sql profiler?

1017

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

949

What is your daily office routine?

2224

How many indexes can be created on a table in sql?

998

Can we connect to postgresql using sql developer?

946

How do you exit in sql?

1073