There are two tables (T1, T2) with different rows. Find the
output of query. Select count(*) from T1,T2.
Answer Posted / prabhash yadav
yes multiply both tables rows
Is This Answer Correct ? | 23 Yes | 0 No |
Post New Answer View All Answers
What do you do in data exploration
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How do you migrate data from mssql server to azure?
Explain the difference between cross join and full outer join?
What is change tracking in sql server?
What is query cost in sql server?
How many replicas are maintained for each sql azure db?
Explain what are the database objects? : SQL Server Architecture
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Define union, union all, minus, intersect?
What is table join?
Explain unique key in sql server?
What are the advantages of mirroring?
How do I start sql server 2016?
How do I view a script in sql server?