What is difference between inner join and cross join?
No Answer is Posted For this Question
Be the First to Post Answer
Question: Below is the table city gender name delhi male a delhi female b mumbai male c mumbai female d delhi male e I want the o/p as follows: male female delhi 2 1 mumbai 1 1 Please help me in writing the query that can yield the o/p mentioned above?
what are myisam tables? : Sql dba
How can you fetch first 5 characters of the string?
How you will create Toad Function?
Why do we need pl sql?
Is merge a dml statement?
What is scalar function in sql?
Explain the steps needed to create the scheduled job?
What is the use of primary key?
please explain database architecture..
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
Can you select everything, but 1 or 2 fields, without writer's cramp?
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)