Click here to Skip to main content
15,883,975 members
Home / Discussions / Database
   

Database

 
GeneralRe: Using the LIKE keyword in a query Pin
reegan4125-Jun-07 8:51
reegan4125-Jun-07 8:51 
GeneralRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 9:01
Kschuler25-Jun-07 9:01 
QuestionSQL XML 3 BulkLoad Error Pin
Panchal Hardik25-Jun-07 2:28
Panchal Hardik25-Jun-07 2:28 
AnswerRe: SQL XML 3 BulkLoad Error Pin
Dave Kreskowiak25-Jun-07 4:05
mveDave Kreskowiak25-Jun-07 4:05 
QuestionSQL CE Query Performance Pin
Ferudun Atakan24-Jun-07 22:44
Ferudun Atakan24-Jun-07 22:44 
AnswerRe: SQL CE Query Performance Pin
andyharman24-Jun-07 23:12
professionalandyharman24-Jun-07 23:12 
QuestionSelect unique column??? Pin
Doan Quynh24-Jun-07 22:26
Doan Quynh24-Jun-07 22:26 
AnswerRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 22:31
Colin Angus Mackay24-Jun-07 22:31 
Something like this:
SELECT o.ID, s.IDUser, s.Year
FROM MyTable AS o
INNER JOIN (SELECT IDUser, MAX(Year)
            FROM MyTable
            GROUP BY Year) AS s 
ON o.IDUser = s.IDUser AND o.Year = s.Year



Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
* Reading: Developer Day 5

Ready to Give up - Your help will be much appreciated.


My website

GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:49
Doan Quynh24-Jun-07 22:49 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:54
Doan Quynh24-Jun-07 22:54 
GeneralRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 23:50
Colin Angus Mackay24-Jun-07 23:50 
Questionyou tried to execute a query that doesn't include the specified expression Pin
nitin324-Jun-07 21:58
nitin324-Jun-07 21:58 
AnswerRe: you tried to execute a query that doesn't include the specified expression Pin
Krish - KP24-Jun-07 22:12
Krish - KP24-Jun-07 22:12 
Questionhelp Pin
nisha thakur24-Jun-07 21:11
nisha thakur24-Jun-07 21:11 
AnswerRe: help Pin
gauthee24-Jun-07 21:13
gauthee24-Jun-07 21:13 
QuestionQuery regarding connecting database Pin
John.L.Ponratnam24-Jun-07 21:03
John.L.Ponratnam24-Jun-07 21:03 
AnswerRe: Query regarding connecting database Pin
rah_sin24-Jun-07 21:10
professionalrah_sin24-Jun-07 21:10 
GeneralRe: Query regarding connecting database Pin
John.L.Ponratnam24-Jun-07 21:30
John.L.Ponratnam24-Jun-07 21:30 
Questiontracing error Pin
mohd imran abdul aziz24-Jun-07 20:26
mohd imran abdul aziz24-Jun-07 20:26 
QuestionViewing Size of a Record Pin
xbiplav24-Jun-07 20:05
xbiplav24-Jun-07 20:05 
AnswerRe: Viewing Size of a Record Pin
andyharman24-Jun-07 22:59
professionalandyharman24-Jun-07 22:59 
QuestionTrigger Manipulation [modified] Pin
M. J. Jaya Chitra24-Jun-07 19:33
M. J. Jaya Chitra24-Jun-07 19:33 
AnswerRe: Trigger Manipulation Pin
Sathesh Sakthivel24-Jun-07 20:04
Sathesh Sakthivel24-Jun-07 20:04 
GeneralRe: Trigger Manipulation Pin
M. J. Jaya Chitra24-Jun-07 21:04
M. J. Jaya Chitra24-Jun-07 21:04 
AnswerRe: Trigger Manipulation Pin
gauthee24-Jun-07 21:16
gauthee24-Jun-07 21:16 

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.