Introduction of rollup clause using sum and group by clause?
No Answer is Posted For this Question
Be the First to Post Answer
What is built-in/administrator?
What is the maximum size of a row in sql server?
Tell me what is the order in which the sql query is executed?
How will you know when statistics on a table are obsolete?
what is memory-optimized nonclustered indexes
How do we know if any query is retrieving a large amount of data or very little data?
how to replace double quotes by single quotes in sql server
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
What is the difference between locking and multi-versioning?
Write a sql query to delete duplicate records from a table called table1
Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.
What is primary key index?
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)