1. Which is an aggregate function?
a. Union b. like c. max d. Rank
Define concurrency control. : Transact sql
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
How do I find duplicates in two columns?
how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900
How do you update a sql procedure?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
How do I truncate a sql log file?
Is not equal in sql?
what is union? : Sql dba
What is the difference between DELETE and TRUNCATE?
15 Answers Johns Hopkins University, Tech Mahindra,
what is the command for user data type?
Oracle (3253)
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)