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

Answer Posted / aditya

select *from <table name>where sal<20

Is This Answer Correct ?    7 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary key index?

542


Define primary key?

662


Does hive support indexing?

525


What is page-level compression?

558


How you provide security to cube? : sql server analysis services, ssas

542






How many types of built in functions are there in sql server 2012?

494


How to create new tables with "select ... Into" statements in ms sql server?

518


What is coalesce and check constraint in sql server?

552


What is the difference between coalesce() & isnull()?

535


What is the concept of optimization?

573


What is the difference between a "where" clause and a "having" clause?

623


Does sql server 2000 clustering support load balancing?

574


What are four major operators that can be used to combine conditions on a where clause?

600


Can you explain what are various ways to enhance the ssrs report?

585


Why normalization is used?

559