Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 4439 Views
- I also Faced
- E-Mail Answers
Answer Posted / milena
Hi here is my sql code, tested and works :
select t.CityName As 'CityName1',t.CityTemp
As 'CityTemp1' ,t1.CityName As 'CityName2',t1.CityTemp
As 'CityTemp2',(t1.CityTemp-t.CityTemp)*(-1) As Difftemp
From Test as t inner join Test As t1
on
t1.CityId=t.CityId+1
Result is :
Delhi 40 Mumbai 35 5
Mumbai 35 Jammu 32 3
Jammu 32 Pune 18 14
If you want to remove the CityTemp1, CityTemp2, you can do
so from select statement. :)
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what are acid properties? : Sql server database administration
Can you explain what are various ways to enhance the ssrs report?
What is dknf in normalization form?
Explain foreign key in sql server?
Ways to improve the performance of a SQL Azure Database?
Will the writetext statement activate a trigger?
what is the difference between Tabular and Matrix report?
Explain about SQL server 2005?
Difference between uniqe index and uniqe constraint?
Can a rule be bound to any column of any data type?
What is dml command?
why would you use sql agent? : Sql server database administration
How many replicas are maintained for each SQL Azure database?
What is stored in the mssqlsystemresource database? : sql server database administration
Where do you find the default Index fill factor and how to change it?
