Database

select columns from tablename where somecolumn = (select someColumn1 from sometableone)

select a.ticker from table as a inner join table as b 
on a.ticker=b.ticker and a.price>b.price 
where a.date='11/20/2009' and b.date='11/17/2009' 
group by a.ticker;

SELECT TOP 1 mycolumn FROM mytable

SELECT 
    Table_Name = Name, 
    Row_Count = DCount("*",[MSysObjects].[Name]) 
FROM 
    MSysObjects 
WHERE 
    (Left([Name],1)<>"~") 
    AND (Left([Name],4) <> "MSys") 
    AND ([Type] In (1, 4, 6)) 
ORDER BY 
    Name

I are Troll

OleDbConnection con = new OleDbConnection("Provider=microsoft.jet.oledb.4.0; data source="+Server.MapPath("~/App_Data/Sample.mdb"));
con.Open();
DataTable dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] {null, null, null, "TABLE"}); 
con.Close();

sekhar.k wrote:

I got one more alternative for that...

I are Troll