Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How many queries?

Status
Not open for further replies.

JasonXie

Programmer
Feb 4, 2001
20
0
0
NZ
Hello, All:

These might be stupid questions.

First:
For a given table with 10 attributes, without knowing the type of the attributes, without knowing any specified requirements, how many queries can be generated on this single table by using as many combinations of SQL query keywords as possible.

Second:
For two given tables with one having 10 attributes and the other having 5 attributes, without knowing which attributes can be used for join them together, how many queries can be generated on these two tables without caring about any sense ?

Can anyone give me formulas to calculate them?

Many thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top