Click here to Skip to main content
15,868,073 members
Home / Discussions / Database
   

Database

 
AnswerRe: NDF File Pin
Richard Deeming24-Mar-15 9:15
mveRichard Deeming24-Mar-15 9:15 
AnswerRe: NDF File Pin
Richard Deeming24-Mar-15 9:18
mveRichard Deeming24-Mar-15 9:18 
QuestionHelp needed on string function Pin
Ambertje24-Mar-15 6:01
Ambertje24-Mar-15 6:01 
AnswerRe: Help needed on string function Pin
Kornfeld Eliyahu Peter24-Mar-15 7:42
professionalKornfeld Eliyahu Peter24-Mar-15 7:42 
GeneralRe: Help needed on string function Pin
Ambertje24-Mar-15 23:43
Ambertje24-Mar-15 23:43 
GeneralRe: Help needed on string function Pin
Johan Hakkesteegt8-Apr-15 2:36
Johan Hakkesteegt8-Apr-15 2:36 
QuestionVB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 4:33
Pauls Pauls21-Mar-15 4:33 
AnswerRe: VB.NET MYSQL DATATABLE Pin
Peter Leow21-Mar-15 4:56
professionalPeter Leow21-Mar-15 4:56 
First thing first, redesign the marks table as follows:
studentno    subjectid    mark
20              1          50
20              2          60
20              3          70
20              4          60
21              1          70
...            ...        ...

The subjectid of the marks table will be the foreign key referencing the subjectid (primary key) of the subject table
The SQL query to retrieve the desire marks by subject by student will be:
SQL
SELECT s.subjectname, m.mark FROM marks m inner join subjects s
on m.subjectid = s.subjectid WHERE studentno = 20

Find out more on http://www.datanamic.com/support/lt-dez005-introduction-db-modeling.html[^]
AnswerRe: VB.NET MYSQL DATATABLE Pin
manchanx21-Mar-15 5:14
professionalmanchanx21-Mar-15 5:14 
GeneralRe: VB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 6:16
Pauls Pauls21-Mar-15 6:16 
QuestionOracle, inner join and substr function Pin
Ludwing RS20-Mar-15 9:29
Ludwing RS20-Mar-15 9:29 
AnswerRe: Oracle, inner join and substr function Pin
Eddy Vluggen20-Mar-15 10:21
professionalEddy Vluggen20-Mar-15 10:21 
AnswerRe: Oracle, inner join and substr function Pin
Jörgen Andersson20-Mar-15 13:20
professionalJörgen Andersson20-Mar-15 13:20 
GeneralRe: Oracle, inner join and substr function Pin
Ludwing RS23-Mar-15 8:02
Ludwing RS23-Mar-15 8:02 
QuestionSSRS merging main header of two columns into one and then splitting subheadings Pin
indian14316-Mar-15 12:39
indian14316-Mar-15 12:39 
QuestionSSRS Report not allowing to edit name of the field Pin
indian14316-Mar-15 11:44
indian14316-Mar-15 11:44 
AnswerRe: SSRS Report not allowing to edit name of the field Pin
Richard Deeming17-Mar-15 3:42
mveRichard Deeming17-Mar-15 3:42 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 12:46
indian14318-Mar-15 12:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 7:10
rafael.avaria16-Mar-15 7:10 
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 6:38
delgaillo12-Mar-15 6:38 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 14:51
professionalMycroft Holmes12-Mar-15 14:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 22:12
delgaillo12-Mar-15 22:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 22:14
professionalMycroft Holmes12-Mar-15 22:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 0:17
delgaillo28-Sep-15 0:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 14:25
Member 115083508-Mar-15 14:25 

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.