ElaKiri Community
Downloads
Go Back   ElaKiri Community > General > ElaKiri Talk!
Reload this Page SQL Query Help!
Reply
 
Thread Tools
(#1)
Old
isurutmv's Avatar
isurutmv isurutmv is offline
Senior Member
isurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura about
 
Posts: 893
Join Date: May 2013
Location: Gampaha
SQL Query Help! - 12-30-2018, 02:29 PM

Mcn Database eke Table ekak thiyenawa me widihata 456,675 kiyanne employee numbers mata danaganna one 656 kiyana employee mona team ekeda kiyala meka karanne kohomada samanya where clause ekak liyannath bane mekata


Reply With Quote
(#2)
Old
ArunaTelshan's Avatar
ArunaTelshan ArunaTelshan is offline
Senior Member
ArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to behold
 
Posts: 2,817
Join Date: Nov 2013
Location: Biyagama
Send a message via ICQ to ArunaTelshan Send a message via Skype™ to ArunaTelshan
12-30-2018, 02:47 PM

column name eka ne ganna one.. Select column_name From tablename whare TEAM1="656" OR TEAM2="656" OR TEAM3="656" OR TEAM4="656" kiyala dammoth enne nadda
Reply With Quote
(#3)
Old
Reo_BitPA Reo_BitPA is offline
Member
Reo_BitPA is on a distinguished road
 
Posts: 61
Join Date: Jan 2018
12-30-2018, 02:49 PM

Quote:
Originally Posted by isurutmv View Post
Mcn Database eke Table ekak thiyenawa me widihata 456,675 kiyanne employee numbers mata danaganna one 656 kiyana employee mona team ekeda kiyala meka karanne kohomada samanya where clause ekak liyannath bane mekata



Employee mona team eketa aithida kiyala mona table ekadat thiyenne ? or one employeee can have many teams ? wenewama mapping thiyaganna table ekak thiyanwada
Reply With Quote
(#4)
Old
ArunaTelshan's Avatar
ArunaTelshan ArunaTelshan is offline
Senior Member
ArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to beholdArunaTelshan is a splendid one to behold
 
Posts: 2,817
Join Date: Nov 2013
Location: Biyagama
Send a message via ICQ to ArunaTelshan Send a message via Skype™ to ArunaTelshan
12-30-2018, 02:49 PM

column name eka me wage ekakin gaththahaki

sys.columns.name AS ColumnName,

nathnam oken pivot table ekak hadagaththanam lesi
Reply With Quote
(#5)
Old
biskubiskulahila's Avatar
biskubiskulahila biskubiskulahila is offline
Senior Member
biskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of lightbiskubiskulahila is a glorious beacon of light
 
Posts: 943
Join Date: May 2013
Location: Waikkal
12-30-2018, 02:54 PM

https://stackoverflow.com/questions/...umn-contains-x
Reply With Quote
(#6)
Old
isurutmv's Avatar
isurutmv isurutmv is offline
Senior Member
isurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura about
 
Posts: 893
Join Date: May 2013
Location: Gampaha
12-30-2018, 02:59 PM

Quote:
Originally Posted by Reo_BitPA View Post
Employee mona team eketa aithida kiyala mona table ekadat thiyenne ? or one employeee can have many teams ? wenewama mapping thiyaganna table ekak thiyanwada
Employeege team eka wenas wenawa bn dawasin dawasa employeege team eka thiyenne me table eke
Reply With Quote
(#7)
Old
rangakw rangakw is offline
Banned
rangakw is infamous around these parts
 
Posts: 711
Join Date: Jun 2007
12-30-2018, 03:03 PM

sql IF ELSE walin goda danna puluwan nehda?
Reply With Quote
(#8)
Old
lankanatha's Avatar
lankanatha lankanatha is offline
Senior Member
lankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of lightlankanatha is a glorious beacon of light
 
Posts: 3,659
Join Date: Dec 2008
12-30-2018, 03:08 PM

select 'Team1' as Team from Table where
Team1= pemp_id
union all
select 'Team2' as Team from Table where
Team2= pemp_id
union all
select 'Team3' as Team from Table where
Team3= pemp_id
union all
select 'Team4' as Team from Table where
Team4= pemp_id
Reply With Quote
(#9)
Old
saja's Avatar
saja saja is offline
Senior Member
saja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to beholdsaja is a splendid one to behold
 
Posts: 6,836
Join Date: Jan 2007
Location: Home Sweet Home
12-30-2018, 03:13 PM

team1..... team4 ochara da teams gana?
Reply With Quote
(#10)
Old
isurutmv's Avatar
isurutmv isurutmv is offline
Senior Member
isurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura aboutisurutmv has a spectacular aura about
 
Posts: 893
Join Date: May 2013
Location: Gampaha
12-30-2018, 03:19 PM

Quote:
Originally Posted by lankanatha View Post
select 'Team1' as Team from Table where
Team1= pemp_id
union all
select 'Team2' as Team from Table where
Team2= pemp_id
union all
select 'Team3' as Team from Table where
Team3= pemp_id
union all
select 'Team4' as Team from Table where
Team4= pemp_id
meken team eka balaganna bane bn
Reply With Quote
Reply

Bookmarks

Tags
sql

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



Copyright © 2006 - 2011 ElaKiri™ Beta2.Evo vBulletin, vBa iBproArcade Subdreamer I-Magic MKv

Page generated in 0.02136 seconds with 9 queries