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

How you provide security to cube? : sql server analysis services, ssas

0 Answers  


What are the acid properties?

0 Answers  


How to copy the tables, schema and views from one sql server to another?

0 Answers  


What is hot add cpu in sql server 2008?

0 Answers  


I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,






How can a database be repaired?

0 Answers  


What is de-normalization and what are some of the examples of it?

0 Answers  


Do you know data definition language, data control language and data manipulation language?

0 Answers  


What does select 1 mean?

0 Answers  


What are binary string data types in ms sql server?

0 Answers  


can any one please send sql quries most used in applications.

2 Answers  


What is the Disadvantage of indexed sequential file.

0 Answers   HCL,


Categories