Sql Help

[adavilo anna]

can anyone help me with two or three sql statements??

[adavilo anna]

helpppp

[Josh]

Problem ikkada post chey bro, members will give suggestions

[adavilo anna]

nenu SQL ki newbie.. all these days i was into pharmacy..so plz navvakandi naa questions ki

 

hers is my question:

 

Basic query that will extract the specific information  from a table

[adavilo anna]

I have a table X with 10 attributes(say 1-10), so i want to selct only 5(say 2,4,5,8,10)

[Spartan]

SELECT select_list
FROM source
WHERE condition(s)
GROUP BY expression
HAVING condition
ORDER BY expression

[adavilo anna]

SELECT select_list
FROM source
WHERE condition(s)
GROUP BY expression
HAVING condition
ORDER BY expression

 

Bhayya thanks plz check ur PM

[Spartan]

Bhayya thanks plz check ur PM

 

naak PM lu raavu..

[adavilo anna]

yeah ipudey ardham ayindhiii

[adavilo anna]

gh

[adavilo anna]

j

[adavilo anna]

j

[Spartan]

 

Create a basic query that will extract the following information from the tblProduct table: ingproductid, strproductname, chkinstock, Ingunitsinstock, ingshippingid.  

 

 

 

 

 

from data model in above URL

 

 

SELECT ingproductid, strproductname, chkinstock, Ingunitsinstock, ingshippingid
FROM tblProduct;

[adavilo anna]

SELECT ingproductid, strproductname, chkinstock, Ingunitsinstock, ingshippingid
FROM tblProduct;

thank u so much, inka oka last question undhiii

[adavilo anna]

a