Click here to Skip to main content
15,794,377 members
Home / Discussions / Database
   

Database

 
GeneralRe: ask about mammogram Pin
JOAT-MON29-May-12 10:39
JOAT-MON29-May-12 10:39 
GeneralRe: ask about mammogram Pin
JohnPayton29-May-12 14:04
JohnPayton29-May-12 14:04 
QuestionBatch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov28-May-12 11:39
Dmitri Novikov28-May-12 11:39 
AnswerRe: Batch reporting framework for Oracle databases. Needed? Pin
Eddy Vluggen29-May-12 1:54
professionalEddy Vluggen29-May-12 1:54 
GeneralRe: Batch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov29-May-12 9:22
Dmitri Novikov29-May-12 9:22 
AnswerRe: Batch reporting framework for Oracle databases. Needed? Pin
Eddy Vluggen29-May-12 9:51
professionalEddy Vluggen29-May-12 9:51 
GeneralRe: Batch reporting framework for Oracle databases. Needed? Pin
Dmitri Novikov29-May-12 10:35
Dmitri Novikov29-May-12 10:35 
NewsDatabase driven Controls Pin
mauricemcse25-May-12 4:27
mauricemcse25-May-12 4:27 
GeneralRe: Database driven Controls Pin
Corporal Agarn27-May-12 2:58
professionalCorporal Agarn27-May-12 2:58 
QuestionLinking ITS Typing Test System to database Pin
abhijitp8423-May-12 0:01
abhijitp8423-May-12 0:01 
AnswerRe: Linking ITS Typing Test System to database Pin
Mycroft Holmes23-May-12 14:00
professionalMycroft Holmes23-May-12 14:00 
QuestionSQL Query Issue Pin
Nayan Ambaliya22-May-12 20:09
Nayan Ambaliya22-May-12 20:09 
Dear all,

I have this sort of weird question in terms of sql data and query.

Consider the dataset below. I have this results in to a table variable (SQL 2008)

SQL
EmailAddress          ID
----------------------------
abc@test.com          1000
def@test.com          1001
ppp@test.com          1002
iii@test.com          1002
ttt@test.com          1000
----------------------------


Now, what I want out of this table variable is the below result

SQL
EmailAddress          ID
----------------------------
abc@test.com          1000
def@test.com          1001
ppp@test.com          1002
----------------------------


What I want is to have first available unique ID and their email address. Can anyone please write a query or direct me.

Thanks.
AnswerRe: SQL Query Issue Pin
Mycroft Holmes22-May-12 23:36
professionalMycroft Holmes22-May-12 23:36 
AnswerRe: SQL Query Issue Pin
vvashishta25-May-12 0:44
vvashishta25-May-12 0:44 
AnswerRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 1:01
professionalEddy Vluggen25-May-12 1:01 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 1:22
subeditorPete O'Hanlon25-May-12 1:22 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 1:25
professionalEddy Vluggen25-May-12 1:25 
GeneralRe: SQL Query Issue Pin
Pete O'Hanlon25-May-12 2:23
subeditorPete O'Hanlon25-May-12 2:23 
GeneralRe: SQL Query Issue Pin
Eddy Vluggen25-May-12 2:28
professionalEddy Vluggen25-May-12 2:28 
QuestionCould anyone recommend an interactive application for mass data analysis? Pin
bestbird778822-May-12 17:24
bestbird778822-May-12 17:24 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen23-May-12 1:30
professionalEddy Vluggen23-May-12 1:30 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778823-May-12 21:56
bestbird778823-May-12 21:56 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen24-May-12 1:26
professionalEddy Vluggen24-May-12 1:26 
GeneralRe: Could anyone recommend an interactive application for mass data analysis? Pin
bestbird778824-May-12 17:53
bestbird778824-May-12 17:53 
AnswerRe: Could anyone recommend an interactive application for mass data analysis? Pin
Eddy Vluggen25-May-12 1:04
professionalEddy Vluggen25-May-12 1:04 

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.