How optimize sql query with multiple joins in sql server?
- 0 Answers
- 502 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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
can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)
How to see the event list of an existing trigger using sys.trigger_events?
What function does a database engine serve in the sql server?
Distinguish between commit and rollback?
what do you understand by change data capture?
How many instances per computer are there in sql server 2000?
what is hash table
Can you explain about buffer cash and log cache in sql server?
How use inner join in sql server?
What are the common performance issues in sql server?
What are the requirements on sql server network connections?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
