select count(case when sal > 2000 then 1 else 0 end) as cnt1,
count(case when sal >5000 then 1 else 0 end) as cnt2
from emp
**********************************************
Contents
- AddEditDelete-Advanced
- AJAX - How to say Hello
- Common Functions
- CONVERT DD-MM-YYYY TO MM/DD/YYYY
- Convert dd/mm/yyyy to mm/dd/yyyy
- CONVERT ID TO NAME
- Convert mm/dd/yyyy to dd/mm/yyyy format in classic asp
- displaying timetable
- First Record Skipped by ASP.NET
- Free Photo Web sites
- get data from excel using asp
- How to convert mm/dd/yyyy to dd-mmm-yy in classic asp
- How to convert mmddyyyy into ddmmyyyy in classic asp
- Javascript : Country-State DropDown
- ORACLE SQL CASE-END
- Oracle Table to Insert Statements
- Random Number in Classic ASP
- Rs.RecordCount
- Select Box Template