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
- 4527 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 joins in sql and what are the different types of joins?
What is the chart in report?
What is the difference between executequery () and executeupdate ()?
How do I connect to sql server database?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is index, cluster index and nonclustered index?
What is exporting utility?
What is sql server profiler?
Can you pass expressions to function parameters?
Name the different type of indexes in sql?
Explain different types of lock modes in sql server 2000?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
Explain the use of containers in ssis and also their types?
What do you need to connect php to sql server?
What is the difference between dropping a database and taking a database offline?
