How do we use distinct statement? What is its use?
No Answer is Posted For this Question
Be the First to Post Answer
what is difference between stored procedures and application procedures,stored function and application function?
What is natural join in sql?
Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
29 Answers Alps, Aricent, Bank Of America, Wipro,
Why triggers are used?
What is relationship? How many types of relationship are there?
Can we use commit inside a trigger?
What is sql performance tuning?
what is a trigger in mysql? : Sql dba
Can we call a function containing dml statements in a select query?
Does normalization improve performance?
How many commands are there in sql?
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)