T-SQL Query

Question

T-SQL Query

sql.pravin

Mr or Mrs. 500

Points: 578
More actions
October 28, 2010 at 7:26 pm

#230965

Hi
I'm new to t sql
Please give me some idea on the following senario,
There are 3 tables
1)table-- BOOKS
columns --title, isbn
ex: the book, 1234
2)table--bookauthor
columns --isbn, auth_id
ex: 1234, pra
1234,vin
3) table--authors
columns---auth_id, auth_name
pra , prakash
vin , vinder
Now i need to find out pair of authors work together more than 2 times
Thanks in advance
pravin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

WayneS SSC Guru Points: 95405 More actions · Answer 1

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables affected, and INSERT statements to put some test data into those tables that shows your problem will go a long way in getting people to look at your issue and help you out. Please include code for what you have already tried. Don't forget to include what your expected results should be, based on the sample data provided. As a bonus to you, you will get tested code back. For more details on how to get all of this into your post, please look at the first link in my signature.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 2

This scream "Homework Problem" to anyone else?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

Lynn Pettis SSC Guru Points: 442447 More actions · Answer 3

Craig Farrell (10/28/2010)
This scream "Homework Problem" to anyone else?

Umm, agree with you I must.

Grant Fritchey SSC Guru Points: 397721 More actions · Answer 4

Can you please show what you've tried that hasn't worked. We're more than willing to help. But, we're not doing your homework for you.

----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software