How to use group functions in the select clause in ms sql server?

Question Posted / sanjeev saxena

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

More SQL Server Interview Questions

Explain insert into select statement?

What is collation sensitivity?

How to create prepared statements using odbc_prepare()?

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

Explain the cursor lock types?

How will you know when statistics on a table are obsolete?

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

What is the recursive stored procedure in sql server?

What is the beast way to write CTE in SQL Server ?

What is the difference between ‘having’ clause and a ‘where’ clause?

Can you please explain the difference between function and stored procedure?

How to create a simple table to test triggers in ms sql server?

For more SQL Server Interview Questions Click Here