What are group functions in query statements in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What is use of dbcc commands?
what is procedure in sql?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How and why use sql server?
What are the functions in sql server?
What is the concept of optimization?
List out the difference between union and union all in sql server?
what type of indexes physically sort data?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18