Why left join is used in sql?
No Answer is Posted For this Question
Be the First to Post Answer
If we have n no of columns in a table, can we add new column in that table with not null constraint?
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
How to use sql statements in pl/sql?
What is thread join () in threading?
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 the usage of the distinct keyword?
what is a relationship and what are they? : Sql dba
Can we insert data into view?
what is single byte over head in oracle..?
Can you have a foreign key without a primary key?
Does sql between include endpoints?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com