How to fetch alternate records from a table?
No Answer is Posted For this Question
Be the First to Post Answer
What is a stored procedure in sql with example?
How to fetch the rows by dynamicaly passing table name through cursor?
How do you remove duplicate records from a table?
What are character functions?
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 is trigger in pl sql with examples?
how will u find statistics of a database objects?
Explain the types of joins in sql?
What is diff between bulk collect and forall
What are the operators used in select statements?
define primary key & secondary key?
What will be the output of this Query? select to_char(trunc(add_months(sysdate-3),mm),mm/dd/yyyy) from dual
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)