What is out parameter used for eventhough return statement can also be used in pl/sql?
No Answer is Posted For this Question
Be the First to Post Answer
Which constraints we can use while creating database in sql?
How does postgresql compare to "nosql"?
Why does %isopen return false for an implicit cursor?
What is meant by Join? What are the different types of Joins available? Explain.
Define commit, rollback and savepoint?
How can you load microsoft excel data into oracle? : aql loader
what is bdb (berkeleydb)? : Sql dba
how do you count the duplicate records in a table
what are the security recommendations while using mysql? : Sql dba
Can we rollback after truncate?
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?
Describe sql comments?
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)