Click here to Skip to main content
15,867,885 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to select persons who didn't pay they'r bill for two mounth Pin
Mycroft Holmes18-Jul-14 14:49
professionalMycroft Holmes18-Jul-14 14:49 
AnswerRe: How to select persons who didn't pay they'r bill for two mounth Pin
PIEBALDconsult18-Jul-14 7:42
mvePIEBALDconsult18-Jul-14 7:42 
Questionhow to select numbers (integers) only? Pin
Jassim Rahma16-Jul-14 22:52
Jassim Rahma16-Jul-14 22:52 
AnswerRe: how to select numbers (integers) only? Pin
Richard MacCutchan16-Jul-14 22:54
mveRichard MacCutchan16-Jul-14 22:54 
AnswerRe: how to select numbers (integers) only? Pin
thatraja16-Jul-14 23:01
professionalthatraja16-Jul-14 23:01 
AnswerRe: how to select numbers (integers) only? Pin
Mycroft Holmes17-Jul-14 12:49
professionalMycroft Holmes17-Jul-14 12:49 
AnswerRe: how to select numbers (integers) only? Pin
PIEBALDconsult17-Jul-14 13:52
mvePIEBALDconsult17-Jul-14 13:52 
GeneralRe: how to select numbers (integers) only? Pin
Jassim Rahma19-Jul-14 22:17
Jassim Rahma19-Jul-14 22:17 
I tried this:

SQL
SELECT employee_number FROM employees WHERE employee_number REGEXP ('[0-9]');


it's working excellent and I getting these numbers

7, 8, 9, 11, 1.222, 12, 13, 9, 15, 9, 9, 9

BUT....

when I run:

SQL
SELECT MAX(employee_number) FROM employees WHERE employee_number REGEXP ('[0-9]');


I get 9 where i should get 15.

why is that?


Technology News @ www.JassimRahma.com

GeneralRe: how to select numbers (integers) only? Pin
PIEBALDconsult20-Jul-14 4:50
mvePIEBALDconsult20-Jul-14 4:50 
QuestionHandle to chat room with mysql database Pin
Member 1094998616-Jul-14 4:08
Member 1094998616-Jul-14 4:08 
AnswerRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 5:02
professionalEddy Vluggen16-Jul-14 5:02 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 7:18
Member 1094998616-Jul-14 7:18 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 7:46
professionalEddy Vluggen16-Jul-14 7:46 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 7:53
Member 1094998616-Jul-14 7:53 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 8:05
professionalEddy Vluggen16-Jul-14 8:05 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 8:09
Member 1094998616-Jul-14 8:09 
GeneralRe: Handle to chat room with mysql database Pin
Eddy Vluggen16-Jul-14 8:24
professionalEddy Vluggen16-Jul-14 8:24 
AnswerRe: Handle to chat room with mysql database Pin
data modeling guy16-Jul-14 17:42
data modeling guy16-Jul-14 17:42 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998616-Jul-14 21:28
Member 1094998616-Jul-14 21:28 
GeneralRe: Handle to chat room with mysql database Pin
data modeling guy16-Jul-14 23:52
data modeling guy16-Jul-14 23:52 
GeneralRe: Handle to chat room with mysql database Pin
Member 1094998617-Jul-14 1:45
Member 1094998617-Jul-14 1:45 
QuestionSSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Mangesh678616-Jul-14 2:04
Mangesh678616-Jul-14 2:04 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
Eddy Vluggen16-Jul-14 5:03
professionalEddy Vluggen16-Jul-14 5:03 
AnswerRe: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Pin
PIEBALDconsult17-Jul-14 13:39
mvePIEBALDconsult17-Jul-14 13:39 
QuestionExtract Data in Single Record Pin
mrfalk15-Jul-14 13:05
mrfalk15-Jul-14 13:05 

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.