Why do we use joins?
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between stored procedure and trigger?
What is dml statement?
How to use distinct and count in sql query? Explain
What do you mean by stored procedures? How do we use it?
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?
Which are the different character-manipulation functions in sql?
Write one update command to update seqno field of a table on the basis of row number.
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is union, minus and interact commands?
What is a package ? What are the advantages of packages ?
Explain commit, rollback and savepoint.
What is compute?