How to count the result from sql statement?

kaiwing18_at_hotmail.com
Date: 02/11/04 

Date: 11 Feb 2004 08:20:38 -0800

Hi,

I want to know how to count the result of sql from oracle9i.
For example,

 "Select * from student where course_id='101'"

if the result is two ppls, how can i retrieve this value
form sql statement?

Thx

Ricky

Relevant Pages

  • Re: Which identity?
    ... > Some postings I read suggested using MAXto retrieve the inserted record ... > each of these 3 SQL features? ... Another way to do it if using the .AddNew method on a Jet based ADO ... Dim rsTest As ADODB.Recordset ...
    (microsoft.public.access.queries)
  • Re: White Paper on How MSAccess interacts with SQL Server Back End
    ... these keys to retrieve the other fields from the tables by group of 10 rows. ... or with VBA functions that Access cannot translate directly into T-SQL ... Sylvain Lafontaine, ing. ... my SQL 2000 db using ACC2003 as the front end via linked tables. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
    ... I am using an Access update query, with parameters, for the ... Then my app goes against a SQL ... OleDbDataAdapter that I use to retrieve the original table from the ... So your named parameters for SQL Server suddenly become anonymous ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
    ... Then my app goes against a SQL ... Server 2000 database, retrieves other data and updates about 500 ... OleDbDataAdapter that I use to retrieve the original table from the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Linq. Select.
    ... The SQL way is to order by a GUID and select the top 10 rows. ... Unfortunately, SQL is made to retrieve the rows you specify, not just ... Lead developer of LLBLGen Pro, the productive O/R mapper for .NET ... My .NET blog: http://weblogs.asp.net/fbouma ...
    (microsoft.public.dotnet.languages.csharp)