Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-26 : 12:48:14
|
Maria writes "Hi, I'm working on a query running on the Microsoft SQL to output the first record of each au_id for the following example table "titleauthor" in the "pub" database. Both au_id and title_id are the keys of the table. I need to output the records in (*).
au_id / title_id
(*)172-32-1176 / PS3333
(*)213-46-8915 / BU1032
213-46-8915 / BU2075
(*)238-95-7766 / PC1035
(*)267-41-2394 / BU1111
267-41-2394 / TC7777
(*)274-80-9391 / BU7832
(*)409-56-7008 / BU1032
(*)427-17-2319 / PC8888
(*)472-27-2349 / TC7777
(*)486-29-1786 / PC9999
486-29-1786 / PS7777
Is there any aggregate function like First(au_id)??
THank you.
-Maria" |
|
|
|
|
|
Can this be done in one simple select statement?