Which function is used to return remainder in a division operator in sql?
No Answer is Posted For this Question
Be the First to Post Answer
What is query optimization in sql?
Explain what is a field in a database and record in a database?
How do you clear the screen in sql?
which types of join is used in sql widely? : Sql dba
how to check the 3rd max salary from an employee table?
What is the difference between nested table and varray?
select 1,col1,col2 from table1. output?
How do I find duplicates in two columns?
how are rank and dense rank being alloted for column with same values over a particular column
Why is sharding used?
what is the difference between undefined value and null value? : Sql dba
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)