how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What new changes are being made in SQL Server?

0 Answers   Blue Star,


What the different types of Replication and why are they used?

0 Answers  


How to reaname table name without using sp_Rename in sql server..?

0 Answers   Wipro,


How to enter binary string literals in ms sql server?

0 Answers  


What is difference between sql and sql server?

0 Answers  






What is enhanced database mirroring in sql server 2008?

0 Answers  


could u plz explain about joins and views?

2 Answers  


Which system tables contain information on privileges granted and privileges obtained

1 Answers  


How optimize sql query with multiple joins in sql server?

0 Answers  


What do you mean by data manipulation language?

0 Answers  


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

0 Answers  


What is an inner join?

0 Answers  


Categories