|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
March 19th, 2002, 12:49 PM
|
|||
|
|||
|
select
hi,
How can I construct a SELECT query which select only the latest version of my document?? for eg: I have a same document with different versions... 1,2,3 etc.... I need to select the document which has the latest version ..in this case 3 wud appreciate any help.. TIa, sands
|
|
#2
March 19th, 2002, 01:53 PM
|
||||
|
||||
|
Table structure?
This is a "general database" question anyway. 
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
March 19th, 2002, 02:58 PM
|
|||
|
|||
|
Assuming you've got a variable in the table that contains the date of the doc.... (and if I remember rightly you're using oracle), so try something like this....
select doc from doctable where (doc,date) in (select doc, max(date) from doctable where name='whateveryoucalledit.doc');
|
|
| Viewing: Dev Shed Forums > Programming Languages > Java Help > select |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
