Why do we need a foreign key?
No Answer is Posted For this Question
Be the First to Post Answer
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?
How can we optimize a sql query?
Can We write bulk collect statement in triggers?
Sql technical questions
What is the purpose of a secondary key?
Define sql delete statement.
What are triggers in sql?
Can I call a procedure inside a function?
what is log shipping? : Sql dba
Write a unique difference between a function and a stored procedure.
Does user triggers have entry for trigger with compilation errors?
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)