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
Answer Posted / pradip jain
select t1.name + ' and ' t2.name , t2.temp -t1.temp from
temp t1
join temp t2 on t2.id=t1.id+1
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is spatial nonclustered index
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What are the differences between user defined functions and stored procedures?
what is create database syntax? : Sql server database administration
what is the different types of backups available in sql server? : Sql server database administration
What does this statement do @@rowcount?
How to change server name in sql server?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Can we call stored procedure in view in sql server?
what is package and it uses and how can u call a package
Difference between 2NF &3NF ?
Tell me about normalization in DBMS.
Define Unique Key?
What are the main differences between #temp tables and @table variables and which one is preferred?
How can you control the amount of free space in your index pages?