There must be some column such as 'TECHNOLOGY' that should disti

I have one table,in that table
(1)i have java1.1 version books are 2 and java1.5 version
books are 4.
(2).Net2.0 books are 3, .Net3.5 books are 2
(3)ABC1.6 books are 4, ABC2.0 books are 3.

Now i want output is like

Book Count

Java 6
.Net 5
ABC 7

For this i need sql query, please help me if anyone how to
get this result.

Thanks,
Seenu

Question Posted / oraclecodec

4 Answers
6832 Views
Adea, I also Faced
E-Mail Answers

Answer Posted / oraclecodec

There must be some column such as 'TECHNOLOGY' that should
distinguish java ,.net and ABC apart from their versions.
Then its easier to arrive at a solution

SELECT TECHNOLOGY,COUNT(*) FROM BOOK GROUP BY TECHNOLOGY;

Is This Answer Correct ?

8 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is cross join? : Sql dba

997

Can I call a procedure inside a function?

1012

What are expressions?

1015

Are stored procedures compiled?

926

Why do we create views in sql?

1154

what is the difference between $message and $$message? : Sql dba

998

Why is stored procedure faster than query?

961

What sql database should I use?

1145

What is a loop in sql?

986

What is the difference between cross join and natural join?

1022

What does the acronym acid stand for in database management?

1032

How sql query is executed?

1133

Is a secondary key the same as a foreign key?

1038

Explian rowid, rownum? What are the psoducolumns we have?

1001

Write the alter statement to enable all the triggers on the t.students table.

1125