Find max for varchar

Question

Hi, I am working on a java project where I need to get the latest id id Max(c_id) client Max(c_id) . But there is text (varchar) in my c_id database, so how can I get max?

  Connection conn; Statement st; Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); conn=DriverManager.getConnection("jdbc:odbc:rrr"); st=conn.createStatement(); String query[] ={"SELECT Max(cid) FROM client"}; for(String q : query){ ResultSet rs = st.executeQuery(q); while (rs.next()) { String name = rs.getString("cid"); Text1.setText(name); 

Answer 1

Please note the following:

select * from the sales order using cid desc limit 1,1;

Answer 2

select max(convert(integer, c_id)) or select max(cast(c_id as integer)) should work

Answer 3

Using

  select max(c_id::integer) from tbluser ; 

If you are using postgresql database

Answer 4

Check this,

 SELECT max(convert(c_id, signed)) FROM client 

try this in mysql,

 SELECT max(cast(c_id AS signed)) FROM client 

can you check with cint function to use ms access

Answer 5

Use this query:

select max (convert (cid, DECIMAL)) from the client;

Answer 6

Please use the following query.

select * from customer order c_id desc limit 1,1;

Answer 7

MySQL

 SELECT Max(cast(cid as signed)) FROM client 

Oracle

 SELECT Max(to_number(cid)) FROM client 

MSSQL

 SELECT Max(CONVERT(int, cid)) FROM client