I had already asked a question related to this and having a little more problem in this
i had created the schema in following link
the query works for me. But there is a problem. Data in database may change time to time. in some time there will not be any engr posted if it is okey. when engr is posted then the output changes.
i use a code for the different grade people in a company
1-3 are Engrs, 4-5 are Supdt, 6 and above are Mechanic
i dont want to count Engrs from the table i want to count Supdt & Mechanic only it means the KDPR>=4-5 (Supdt) and kdpr>=6 (Mechanic) should only be counted in this
I am a System Administrator at Vadodara
Hi, the following videos may be helpful:
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?