Problima me SQL Query

[leukonas]

Mporei kapios na grapsei to parakao ston query analyzer kai na mou pei ti apotelesmata pernei?To trexo sti basi norhwind se SQL 2000.Eyxaristo.

 

Sorry ksexasa na grapso to query opote ekan edit.

 

Select *

From Customers

Where ContactName Like 'Maria%'

 

ayto logika emfanizei oles tis egrafes pou to contactname arxiezi apo maria.emena omos mou emfanizei oti nane.

[vagpap]

Δεν γράφεις και το query... για να το τρέξουμε.... ;-)

[makaveli]

Εχω την εντύπωση ότι στο query analyzer το * δεν υφίσταται! Δοκίμασε να γράψεις το query χωρις το * και λογικά θα δουλέψει! Το * είναι σαν να ενοέιται! Οπότε γράψε το παρακάτω:

 

Select

From Customers

Where ContactName Like 'Maria%'

[SaTaNaKoS]

Σωστό ειναι το query που έχεις γράψει...!! Εμένα προσωπικά μου επιστρέφει δύο εγγραφές που πληρούν το where statement....

[leukonas]

SaTaNaKos emena mou epestrefe dio(logika tis dio idies leme)kai merikes akoma...tora omos pou to ksanadokimasa douleeui mia xara.Mallon o sql server efage flasia.Mia akoma aporia.

 

Ayto trexei

 

select productname , categoryname

from products , categories

where products.categoryid=categories.categoryid and categories.categoryname='produce'

 

ayto giati oxi??

 

select productname , categoryname , categoryid

from products , categories

where products.categoryid=categories.categoryid and categories.categoryname='produce'

 

kai gia na trexei thelei ayto?

 

select products.productname , categories.categoryname , categories.categoryid

from products , categories

where products.categoryid=categories.categoryid and categories.categoryname='produce'

[GrMikeD]

wraia kolpa

[leukonas]

GrMikeD ti enoeis???

[sotospez]

select Products.ProductName , Categories.CategoryName , Categories.CategoryID

from Products , Categories

where Products.CategoryID=Categories.CategoryID and Categories.CategoryName='Produce'

 

ayto eipame oti pezi etsi

 

select ProductName , CategoryName , CategoryID

from Products , Categories

where Products.CategoryID=Categories.CategoryID and Categories.CategoryName='Produce'

 

kai oti ayto den pezi

 

lipon to CategoryID iparxi kai ston table a kai sto b kai den kseri pio

na pari kai na soy feri gia to join poy kaneis to kaneis me where kai oxi me kanoniki sindesi SQl Left Outer Join

 

pisteyo na se boithisa

[leukonas]

sotospez sostos ise...diki mou blakeia.apla kolise to kefali mou kai den katalabena ti eftege.fisika ime neos kai akoma matheno.thnx pantos.

[leukonas]

akoma mia aporia.To parakato giati den trexei?

select a.country , a.companyname 'first company' ,b.companyname 'second company' , a.customerid 'first company id' , b.customerid 'second company id'

from customers a , customers b

where a.country = b.country and a.customerid<>b.customerid

group by a.country

fisika panta stin basi northwind

[bandito]

akoma mia aporia.To parakato giati den trexei?

select a.country ' date=' a.companyname 'first company' ,b.companyname 'second company' , a.customerid 'first company id' , b.customerid 'second company id'

from customers a , customers b

where a.country = b.country and a.customerid<>b.customerid

group by a.country

fisika panta stin basi northwind[/quote']

 

Οταν λες δεν τρεχει , τι εννοεις;

Γιατι αυτο χωρις να το τρεξω πουθενα , θυμαμαι απ'εξω το σφαλμα που θα σου βγάζει ο sql server (οπουδηποτε και να το ετρεχες θα στο εβγαζε).

 

Λεει λοιπον, οτι δεν μπορεις να εχεις στο select field που δεν ειναι στο group by.

Τα διαβαζετε ποτε αυτά που γράφει;

 

select max(a.companyname), max(b.companyname), max(a.customerid), max(b.customerid) και θα παιξει.

[leukonas]

ne ego to diabasa alla os neos den polikatalabeno ta sfalmata pou petaei.sigkekrimena bgaze ayto-->>Server: Msg 8120, Level 16, State 1, Line 1

Column 'a.CompanyName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Ego omos den thelo na paro tis times max.thelo apla na kano grouparisma me basi to country.

[bandito]

ne ego to diabasa alla os neos den polikatalabeno ta sfalmata pou petaei.sigkekrimena bgaze ayto-->>Server: Msg 8120' date=' Level 16, State 1, Line 1

Column 'a.CompanyName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Ego omos den thelo na paro tis times max.thelo apla na kano grouparisma me basi to country.[/quote']

 

Δηλαδη θέλεις:

Οσοι ειναι στην ελλάδα (που μπορει να ειναι χιλιοι αυτοί) να σου βρούν σε μια γραμμή, αλλα σε αυτή την μια γραμμή να φαινονται και τα 1000 id.

Μήπως θέλεις order (sort) και δεν το ξερεις;

[leukonas]

bandito ne ayto ithela...telika olo blakeies rotao.

[leukonas]

Lipon alli mia aporia pou exo.Thelo na ekteleso to eksis query.

select *

from customers

where companyname = 'Bon app ' '

 

dld thelo na kano anazitisi ston pinaka customers to onoma Bon app' .pos ginete ayto??Panta apo ti basi northwind