|
Question |
Rating |
View Answer |
|
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? |
|
View Answer |
|
What is the use of CASCADE CONSTRAINTS? |
|
View Answer |
|
The IN operator may be used if you know the exact value you want to return for at least one of the columns. |
|
View Answer |
|
How to sort the rows in SQL? |
|
View Answer |
|
What is the Delete Statements in SQL? |
|
View Answer |
|
The Update Statement in SQL. |
|
View Answer |
|
The INSERT INTO Statements in SQL? |
|
View Answer |
|
The SELECT INTO Statement is most often used to create backup copies of tables or for archiving records? |
|
View Answer |
|
SELECT statements in SQL? |
|
View Answer |
|
Operators used in SELECT statements are? |
|
View Answer |
|
The most important DDL statements in SQL are? |
|
View Answer |
|
What is SQL*Loader? |
|
View Answer |
|
What is Mutating SQL Table? |
|
View Answer |
|
What is SQL Deadlock? |
|
View Answer |
|
What is SQL Integrity? |
|
View Answer |
|
What is Consistency? |
|
View Answer |
|
What is Locking? |
|
View Answer |
|
What is Set Transaction? |
|
View Answer |
|
What is Savepoint? |
|
View Answer |
|
What is Rollback? |
|
View Answer |