Why join is faster than subquery?
No Answer is Posted For this Question
Be the First to Post Answer
What are joins in sql?
what is the difference between delete and truncate commands? : Sql dba
How can you tell the difference between an index and a view?
what is 'mysqladmin' in mysql? : Sql dba
Why self join is used in sql?
How to update salary of employees department wise?
What does the acronym acid stand for in database management?
Can we insert data in view?
What are the two types of exceptions.
what does it mean to have quoted_identifier on? : Sql dba
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
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)