select t1.name + ' and ' t2.name , t2.temp -t1.temp from temp t1

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

Question Posted / pradip jain

2 Answers
4440 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are data regions?

140

Do you know the different ddl commands in sql?

1059

What is 3nf normalization?

1004

What is the exact numeric data type in sql?

1005

What are commit and rollback in sql?

1135

State the difference between union and union all?

933

Please illustrate physical database architecture? : SQL Server Architecture

992

How to execute multiple stored procedures at one time in sql server?

1016

Explain what is the purpose of sql profiler in sql server?

1081

What is the downside of using udf?

1113

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

Do you know the isolation level that sql server support?

965

What is indexed view? How to create it?

1019

how you can get the list of largest tables in a database? : Sql server administration

1058

Explain about the command-line tool SQLCMD?

1096