Every business collects data, and it's the job of the data analyst to analyze, interpret, and communicate that information in a way that will help drive company decisions. Employers will be looking for candidates with strong technical skills as well as a knack for conveying data in an easy to understand way. Expect a fair number of technical questions, which may include an analytical case study and a math brainteaser.
I was aske to specify as many ways to return the rowcount in the table.
I only know of select count(*). I think there are other ways.
Can pivot table perform this function?
Can you please list as many technical questions as you remember? I have interview with MS for a similar position and I hope your questions would help me?.