I have a query works really good in oracle but I need to know how to write in C#.
Pl. help me
SELECT DISTINCT source_year, can
FROM hits_vw
where source_year between 2005 and 2007
Order by source_year Desc
Printable View
I have a query works really good in oracle but I need to know how to write in C#.
Pl. help me
SELECT DISTINCT source_year, can
FROM hits_vw
where source_year between 2005 and 2007
Order by source_year Desc
you write it the exact same way.
as you can see, I did not change anything.Code:string sql = "SELECT DISTINCT source_year, can FROM hits_vw WHERE source_year between 2005 and 2007 ORDER BY source_year DESC";