How to find out name of all employees who has salary less
than 200 Rs.?

Answer Posted / juergen

Is this a real question???? First off, with all the
asterixes is wrong. Just want the employees.

select AiFirstName, AiEmpLastName
from AiEmployees
where AiSalary < 200

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find the source of a table in sql server?

532


Write a program to fetch first 10 records from a file?

607


What is exclusive locks?

542


How to find the version of sql server? : sql server database administration

631


What is meant by referential integrity?

594






What is the new security features added in sql server 2016? : sql server security

623


Define right outer join in sql server joins?

523


What is the function of sql server agent windows service?

540


Explain what role entity and relationship play in an ER diagram.

582


How to sort query output in descending order in ms sql server?

551


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

604


How do I find query history in sql server?

518


What is snapshot report?

129


How many categories of data types used by sql server?

600


Write a sql query to get zero records from a table having n number of records?

711