Count Records

I have following table as books101

BOOK_NO BOOK_NAME AUTHOR_NAME COST CATEGORY
1234 C Dennis 450 System
1235 Oracle Loni 550 Database
1236 Sql Loni 250 Database
1237 Pl/Sql Scott 750 Database

Now I want to List all the authors and book name that has more then 1 book written by them.

pls help

abhi.mys1111
Profile Answers by abhi.mys1111 Questions by abhi.mys1111
Jun 15th, 2012
4
8592

Questions by abhi.mys1111

SQL

Answer

Showing Answers 1 - 4 of 4 Answers

kannandevan
Profile Answers by kannandevan

Jun 15th, 2012
By grouping book and author
Code
 

kannandevan
Profile Answers by kannandevan

Jun 15th, 2012

select book_name,author_name,count(*) from books
group by book_name,author_name
having count(*)>1

Avinash

Jun 24th, 2012

select AUTHOR_NAME,BOOK_NAME from books101
where AUTHOR_NAME in
(select author_name from books101 group by author_name having count(*)>1);