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
- 4315 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
Can sql servers link to other servers?
Why I have to use stored procedures?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Tell me what is difference between clustered and non clustered index?
Explain indexed views?
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is the Disadvantage of indexed sequential file.
What do you mean by an execution plan? Why is it used?
what is the sql equivaent of the dataset relation object ?
Why can there be only one clustered index and not more than one?
What is the impact on other user sessions when creating indexes?
What are the different types of Indexes available in SQL Server?
How do you rename a table in sql server?
What is the difference between NOROW and LOCKROW?
What is the difference between set and select?
