Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

2 Posts

Posted - 03/19/2014 :  17:48:17  Show Profile
(Removed due to DMCA complaint)

Flowing Fount of Yak Knowledge

4614 Posts

Posted - 03/19/2014 :  18:48:30  Show Profile
Sorry this doesn't help with your question, but if you wanted to have some fun, you should tell your teacher that there is no such thing as a record in an RDBMS and see what they say.
Go to Top of Page

Posting Yak Master

169 Posts

Posted - 03/20/2014 :  00:50:40  Show Profile
select distinct id as author_id,name as author_name,
case when Name is not null and = 1 then 3 else 0 end as h_index
from author as a
left join publication as p
on = p.author_id
order by h_index desc,id desc


Edited by - VeeranjaneyuluAnnapureddy on 03/21/2014 00:30:51
Go to Top of Page

Yak Posting Veteran

71 Posts

Posted - 03/20/2014 :  13:05:00  Show Profile
The logic for H-Index would be somewhat like this:
MAX(Cited) <= COUNT(Title) OVER (Partition by Author_ID ORDER BY Author_ID Desc)
And then do as Veera suggested above.

Not an Expert, Just a learner.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000