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
- 4310 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
What are the main sources of data?
What is sql server profiler?
Can sql servers link to other servers?
What is the difference between functions and scalar functions?
What are the components of dbms?
How to retrieve error messages using mssql_get_last_message()?
Explain triggers?
What are the database roles? : sql server security
How to write a query with an inner join in ms sql server?
What is subquery? Explain the properties of a subquery?
What is the difference between createstatement and preparedstatement?
What happens when unicode strings concatenate with non-unicode strings?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Does index slows down insert statements?
How can you tell if a database object is invalid?
