When is the update_statistics command used?
No Answer is Posted For this Question
Be the First to Post Answer
Where do we use pl sql?
What operators deal with null?
What is the purpose of the partition table?
Write a query to find second highest salary of an employee.
Explain the advantages and disadvantages of stored procedure?
What is the relation b/w view and trigger
what is “go” in t-sql? : Transact sql
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Which one is the Best approach to put code, among Triggers and Procedures? Explain?
what are rollup and cube in t-sql? : Transact sql
what is not null constraint? : Sql dba
What is update query?
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)