read total employes

JAYRAM

read total employes

EMP Table AS Follows;

EMPID EMPNAME MGRNo MGRNAME
1 Raj Null RAvi
2 Ram 1 Sam
3 ttt 2 ghg
4 Hari 3 Yogi

from the above EMP Table i wan the output as follows

total no of employes 4

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shankar M13y ago
Hi Vardhan,

What Vulpes said is correct only, Please tell you requirement correctly. In query to get your
expected output try this.

select 'Total No Of Employees : ' + cast (count(*)as varchar) from emp;

Which gets you,

Total No Of Employees : 370
Bryian Tan13y ago
I'm curious, what is not correct?
Satyapriya Nayak13y ago
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Total_count_records { public partial class Form1 : Form { string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["dsn"]; OleDbCommand com; string str; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(ConnectionString); con.Open(); str = "select count(*)from employees"; com = new OleDbCommand(str, con); label1.Text = "Total no of employees: " + com.ExecuteScalar().ToString(); con.Close(); } } }
JAYRAM13y ago
THIS IS NOT CORRECT........
Vulpes13y ago
Try this query:

SELECT COUNT(*) AS [total no of employees] FROM EMP