Groups > comp.databases.ms-sqlserver > #1362

How do I write this sql statement

From	"Tony Johansson" <johansson.andersson@telia.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	How do I write this sql statement
Date	2012-12-08 11:44 +0100
Organization	A noiseless patient Spider
Message-ID	<k9v5ml$7ln$1@dont-email.me> (permalink)

Show all headers | View raw

Hello!

In a field in the database called Cid we have a format like year-35-X
So in the database we can have numbers that can look like this.
 2012-35-1
2012-35-2
...
2012-35-56
2012-35-0145

If I want a select statement that return the largest number for X how can I 
write this ?
So if we have 2012-35-0194 in the database field Cid I want to get back 195 
?

//Tony

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

How do I write this sql statement "Tony Johansson" <johansson.andersson@telia.com> - 2012-12-08 11:44 +0100
  Re: How do I write this sql statement rja.carnegie@gmail.com - 2012-12-08 03:37 -0800
    Re: How do I write this sql statement "Tony Johansson" <johansson.andersson@telia.com> - 2012-12-08 14:31 +0100
      Re: How do I write this sql statement "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2012-12-08 09:15 -0500
  Re: How do I write this sql statement Erland Sommarskog <esquel@sommarskog.se> - 2012-12-08 16:50 +0100
    Re: How do I write this sql statement bill <billmaclean1@gmail.com> - 2013-01-28 22:43 -0800

csiph-web