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

Answer Posted / jay

select * from Employees where Salary <200

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is filtered index?

668


What is meant by dirty read?

564


Can we write trigger for view?

571


What is 'write-ahead log' in sql server 2000 ?

633


What is a deadlock and what is a live lock?

588






Call by value and call by reference in procedure and function, with NOCOPY.

850


Mention the differences between substr and charindex in sql server.

530


What is the server name in sql server?

567


What to check if a User database is locked?

596


Can we use max in where clause?

529


What is the New in SQL server 2008?

587


What is sub query and its properties?

551


How to create user defined functions with parameters?

650


Can two tables share the same primary key?

523


Tell me extended events in sql server 2008?

567