Can we use where clause in union?
No Answer is Posted For this Question
Be the First to Post Answer
Suppose i have one sql query that contains 2 minute to execute.After one weekly i am executing same query that is taking 5 minute.Why our same query is taking more time.what would be my approach to reduce execution time.Please help.
1 Answers Cognizant, HCL, Value Labs,
wat is mean by normalization?......programing defination i need...(i know basic defination)
Can an entity have two primary keys?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are the pre-defined functions in the sql server?
Explain system functions or built-in functions? What are different types of system functions?
What is default constraint?
What is a print index?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
When we should use @@error?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
what is raid and what are different types of raid configurations? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)