What is rtm stands for?
No Answer is Posted For this Question
Be the First to Post Answer
Which data type is a composite type?
How to select unique records from a table?
What are few of the schema objects that are created using PL/SQL?
What is a dirty read sql?
Explain the methods used to protect source code of pl/sql.
What is rowtype?
What are Global Temporary tables
What is meant by truncate in sql?
Enlist some predefined exceptions?
Explain the purpose of %type and %rowtype data types?
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,
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?
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)