Click here to Skip to main content
15,848,904 members
Home / Discussions / Database
   

Database

 
QuestionRe: Can not connect to my database from asp .net application Pin
Richard Deeming7-Jul-14 4:14
mveRichard Deeming7-Jul-14 4:14 
AnswerRe: Can not connect to my database from asp .net application Pin
Hemant Singh Rautela7-Jul-14 4:31
professionalHemant Singh Rautela7-Jul-14 4:31 
QuestionComplex SQL queries Pin
data modeling guy3-Jul-14 6:14
data modeling guy3-Jul-14 6:14 
AnswerRe: Complex SQL queries Pin
Richard MacCutchan3-Jul-14 6:22
mveRichard MacCutchan3-Jul-14 6:22 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:02
data modeling guy3-Jul-14 21:02 
AnswerRe: Complex SQL queries Pin
PIEBALDconsult3-Jul-14 6:53
mvePIEBALDconsult3-Jul-14 6:53 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:03
data modeling guy3-Jul-14 21:03 
AnswerRe: Complex SQL queries Pin
Eddy Vluggen3-Jul-14 12:24
professionalEddy Vluggen3-Jul-14 12:24 
data modeling guy wrote:

Hello- can you give me any example
scenarios/questions for writing a complex SELECT statements? My intention is to
improve my SQL skills.
  • Calculate reputation points of a user.
  • Fetch the contibutions-section for a user (see the section on your user-page; it contains some statistics)
  • Fetch the ten members from the database that answered most questions last month.
  • Fetch the voting-percentages for the straw-poll result for all possible answers.
  • Fetch any low-repuation member that posts the same message in multiple places, ordered by the amount of similar messages.
  • Fetch the data to show the forum-content for page 3 of this forum, in threaded view, with 50 posts per page.

Roll eyes | :rolleyes:
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Complex SQL queries Pin
Mycroft Holmes3-Jul-14 15:20
professionalMycroft Holmes3-Jul-14 15:20 
GeneralRe: Complex SQL queries Pin
data modeling guy3-Jul-14 21:05
data modeling guy3-Jul-14 21:05 
AnswerRe: Complex SQL queries Pin
Jörgen Andersson3-Jul-14 21:28
professionalJörgen Andersson3-Jul-14 21:28 
QuestionSQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 17:38
Miller Nguyen29-Jun-14 17:38 
AnswerRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult29-Jun-14 18:45
mvePIEBALDconsult29-Jun-14 18:45 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 23:41
Miller Nguyen29-Jun-14 23:41 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller29-Jun-14 22:19
Bernhard Hiller29-Jun-14 22:19 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:38
professionalJörgen Andersson29-Jun-14 23:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
PIEBALDconsult30-Jun-14 4:39
mvePIEBALDconsult30-Jun-14 4:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 4:53
professionalJörgen Andersson30-Jun-14 4:53 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:39
professionalJörgen Andersson29-Jun-14 23:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 23:52
Miller Nguyen29-Jun-14 23:52 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 0:03
professionalJörgen Andersson30-Jun-14 0:03 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller30-Jun-14 1:38
Bernhard Hiller30-Jun-14 1:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 2:15
professionalJörgen Andersson30-Jun-14 2:15 
AnswerRe: SQL convert(datetime, number) wrong? Pin
GuyThiebaut30-Jun-14 1:52
professionalGuyThiebaut30-Jun-14 1:52 
QuestionMySQL Stored Procs - Pin
ericgahn29-Jun-14 10:08
ericgahn29-Jun-14 10:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.