c# Finding similar values in the database -

-

i created access database , connected c# code. in database, have 2 columns (ip , port). question how find same ip connects different value of port column. other words, want search if same ip connects many different ports. idea?!!

thank you

select ip tablename group ip having count(distinct port) > 1;

Comments

Post a Comment

Popular posts from this blog

c++ - list<myClass<int> * > sort -

-
i cannot sort list contains pointers objects of template class. template class node{ public: node(void){} node(t choice, vector<t> & data); node(t choice, vector<t> & data, player p, int level, int pos, node<t> *pred, side); void addnodes(void); static list<node<t> * > nodes; friend class mybinomialtree<node<t>, t>; bool sorter(const node<t> * lhs, const node<t> * rhs);// * &lhs doesn't work private: node<t> * left; node<t> * right; t chosen_; vector<t> data_; bool isleaf; //... }; outside class: template<class t> bool node<t>::sorter(const node<t> * lhs, const node<t> * rhs){ if((*lhs).level_==(*rhs).level_){ return (*lhs).pos_<(*rhs).pos_; }else{ return (*lhs).level_<(*rhs).level_; } } and want sort before print, have template<class t> void node<t>::print(void){ ...
Read more

sql server - database first change primary key from int to uniqueidentifier -

-
i trying change primary key in 1 of tables int uniqueidentifier. pointed out in title, taking database first approach using entity framework. the process took remove primary key table in sql designer , renamed column "itemid" "item". i created column named "itemid" , set uniqueidentifier type default newsequentialid(). then deleted column renamed "item" , set "itemid" primary key. i moved visual studio , did update model database gave me error error 1 error 2019: member mapping specified not valid. type 'edm.int32[nullable=false,defaultvalue=]' of member 'itemid' in type 'shoppingmodel.dbfruits' not compatible 'sqlserver.uniqueidentifier[nullable=false,defaultvalue=,storegeneratedpattern=identity]' of member 'itemid' in type 'shoppingmodel.store.dbfruits'. and here model under .tt directory public partial class dbfruits { public dbfruits() { thi...
Read more

mysql - SQL, Recursive Query -

-
Image
can please me query working selecting data's tables wanted display fields connected other fields using recursive query. my table i have self query does'nt output connected , connected fibers query select closure_id, fiber_id , @pv:=fiber_id 'fiber_id2' (select * tbl_map_closure_fiber order closure_id) join (select @pv:=1)tmp closure_id=@pv just askin how can manage ouput both connected closure_id , connected fiber. please 1 . you need join table pair related rows. select t1.fiber_id, t2.fiber_id fiber_id2 tbl_map_closure_fiber t1 join tbl_map_closure_fiber t2 on t1.fiber_id = t2.closure_id http://sqlfiddle.com/#!9/3f83ee/2
Read more