Database

amount1    count1
amount2    count2
amount3    count3
amount4    count4
amount5    count5
...

count1
count4

SELECT COUNT(*) AS Expr1
FROM Current
WHERE Amount > .09

SELECT AID FROM TableA WHERE BID IN
(SELECT BID
FROM TableA
GROUP BY BID HAVING Count(AID) > 1);

.... Where Clockedin = (select max(clockedin) from tblvisitors)

SELECT DISTINCT employee.intEmpID AS ID, employee.strEmpID AS CardReference, 
		CASE WHEN Employee.intStatus = 0 THEN 
			NULL 
        ELSE 
			Employee.strTitle + ' ' + Employee.strForename + ' ' + Employee.strSurname 
		END AS Visitor, 
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 Company FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As Company,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 VisitorCardEmpId FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As ResponsiblePersonnelID,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			dbo.fnGetEmployeeName((SELECT TOP 1 VisitorCardEmpId FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC))
		END As ResponsiblePersonnel,
		CASE Employee.intStatus 
			WHEN 1 THEN
				-1 
			ELSE 
				0 
		END AS ClockedIn,
		CASE WHEN Employee.intStatus = 0 THEN
			NULL
		ELSE
			(SELECT TOP 1 TimeIn FROM tblVisitors WHERE tblVisitors.intEMPId = employee.intEmpId ORDER BY TimeIn DESC)
		END As ArrivalTime
	FROM         Tensor.dbo.tblEmployee AS employee LEFT OUTER JOIN
                      dbo.tblVisitors AS Visitor ON Visitor.intEmpId = employee.intEmpID 
	WHERE     (employee.strEmpID LIKE 'V%')
	ORDER BY CardReference

select ID = Table1.ID
If Table1.Status = 0 Then
Name = Case when Table1.Status = 0 then Table1.Name else Table2.Name end,
Company = case when Table1.Status = 0 then NULL else Table2.Company end
from Table1
inner join Table2 on Table2.ID = Table1.ID

<br />
TRUNCATE TABLE tablename<br />