SQL Query Help

[lilman]

machanla mata me pahala tiyana output eka ganna quary eka liyaganna help ekak denna puluwanda ? mama liyapu eken rows duplicate wenawa.mata one Jobs table eke rows tika penwanna liyaganna



Need this colums with 0 duplicates




My SQL quary

SELECT jobs.job_no, job_types.name AS job_type, clients.name AS client_name, devices.name AS device_name, jobs.model, jobs.serial_no, company_jobs.payment_status, company_jobs.sent_date, company_jobs.received_date, jobs.remarks FROM jobs, job_types, clients, devices, company_jobs WHERE jobs.job_type_id=job_types.id AND jobs.client_id=clients.id AND jobs.device_id=devices.id

Tables

 

[batwise]

job no eken group by karala balanna

 

[kavindagk]

"company_jobs.payment_status" me column eka nisa thama duplicate wenna , balanne hama ekema 0,1 thiyanawa , okata karanne puluwan widiyata thama ekko oyea column eka ain karanne ehema nathnam 1 or 0 walin filter karanne

 

[lilman]

"company_jobs.payment_status" me column eka nisa thama duplicate wenna , balanne hama ekema 0,1 thiyanawa , okata karanne puluwan widiyata thama ekko oyea column eka ain karanne ehema nathnam 1 or 0 walin filter karanne

Meka weene karanne kohomada ban ?

Company jobs eke rows 2i tiyenne.anika company jobs eke ena jobs wala vitarayi payment status enne.

Anith okkogema 0 enna one.oya 0,1 hama ekatama awilla tiyenne kohomada ?

 

[kavindagk]

Meka weene karanne kohomada ban ?

Company jobs eke rows 2i tiyenne.anika company jobs eke ena jobs wala vitarayi payment status enne.

Anith okkogema 0 enna one.oya 0,1 hama ekatama awilla tiyenne kohomada ?

meke thiyana widiyata oyage data set ekema thiyanwa 0,1 kiyala same entry ekatama

https://ibb.co/W205rt1

 

[lilman]

meke thiyana widiyata oyage data set ekema thiyanwa 0,1 kiyala same entry ekatama

https://ibb.co/W205rt1

Job no wenas machan.

 

[hasithayad]

duplicate wenwnam select distinct dapan

 

[Anonymous_Abstract]

oba use karanne oracle nam beri veda karanne nethuwa meyava contact kara ganin

"වැඩ කරන අපේ දෙවියා"

 

[MrFrog]

duplicate wenwnam select distinct dapan

queries troubleshoot කරන්න කම්මැලි උනාම අපිත් ඕක තමයි කරන්නේ. හැබැයි DB performance team එකේ උන් code review එකට දාගන්න එපා

 

[kavindagk]

SELECT
jobs.job_no,
job_types.name AS job_type,
clients.name AS client_name,
devices.name AS device_name,
jobs.model,
jobs.serial_no,
company_jobs.payment_status,
company_jobs.sent_date,
company_jobs.received_date,
jobs.remarks
FROM
jobs,
job_types,
clients,
devices,
company_jobs
WHERE
jobs.job_type_id=job_types.id AND
jobs.client_id=clients.id AND
jobs.device_id=devices.id
jobs.job_no=company_jobs.job_no


meka dala balanne , me link wenna nathi nisa thama duplicate wenna

 

[MatrixReload]

Machan mee karana lesima widiya thamai oya sql wala view ekak hadala required tables add karala, relationship add karala, oyata oone vidiyata result eka enna view ekak hadaganna. eeta passe e view eke SQL query eka copy karala ganna.

 

[lilman]

Machan mee karana lesima widiya thamai oya sql wala view ekak hadala required tables add karala, relationship add karala, oyata oone vidiyata result eka enna view ekak hadaganna. eeta passe e view eke SQL query eka copy karala ganna.

Eka kohomada karanne ?

Step kiyala diyanko.

 

[Fake Hakker]

Mcn company_jobs kiyana table eka map wenne kohomada ?

Company_jobs table eka aran thibunata map karala neti nisa dublicates enawa aththe. Eka poddak balanna.

 

[lilman]

Mcn company_jobs kiyana table eka map wenne kohomada ?

Company_jobs table eka aran thibunata map karala neti nisa dublicates enawa aththe. Eka poddak balanna.

Meke me payment status 0,1 kiyala 2k enne kohomada ban ? Eka hitaganna ba

 

[MihiCherub]

මේ DB එක අවුල් නැද්ද බන්..Serial column එක unique නෑ. ඒ කියන්නෙ වෙන වෙන model වර්ග වල වලට same serials තියෙනවනෙ. ඊලගට model column එක normalize වෙලා නෑ. model column එක normalize කරන්නෙ නැත්නම් මොකටද job type, device name column දෙක normalize කලේ. මේව heavy project නෙමේ නම් ඔච්චර normalize කරන්න එපා බන්. කෙලවෙනව. Theory වලට උගන්නන හැම මගුලම practically කරන්න බෑ.

 

[lilman]

මේ DB එක අවුල් නැද්ද බන්..Serial column එක unique නෑ. ඒ කියන්නෙ වෙන වෙන model වර්ග වල වලට same serials තියෙනවනෙ. ඊලගට model column එක normalize වෙලා නෑ. model column එක normalize කරන්නෙ නැත්නම් මොකටද job type, device name column දෙක normalize කලේ. මේව heave project නෙමේ නම් ඔච්චර normalize කරන්න එපා බන්. කෙලවෙනව.

Me dummy data ban.test karanna nikan damme.

 

[MihiCherub]

Me dummy data ban.test karanna nikan damme.

data neme ban man kiyanne. structure eka. structure eka hariyata haduwama dummy data test karannawath ehema nikan nogalapenna danna bane.

 

[lilman]

data neme ban man kiyanne. structure eka. structure eka hariyata haduwama dummy data test karannawath ehema nikan nogalapenna danna bane.

Meka simple job management system ekak ban.eka nisa echarama awlak na.

 

[hodakolla]

BUMPER

 

[MatrixReload]

Meka weene karanne kohomada ban ?

Company jobs eke rows 2i tiyenne.anika company jobs eke ena jobs wala vitarayi payment status enne.

Anith okkogema 0 enna one.oya 0,1 hama ekatama awilla tiyenne kohomada ?

Machan sql Db ekata giyaama, eeke thiyenawa "View" kiyala ekak. Eeka right side clik kalaama "new view" kiyala ekak enawa. eeka click kalaama oyatge query ekata oone karana table tika add karaganna. Eeta passe karanna puluwan. poddak youtube eke video athi.





Oyat table pick karala oyage view eka hadanakota sql query eka auto build wenawa. uda video deka honda refer karanna. Thawa video athi search karala balanna. patta lesi