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 are different replication agents and what's their purpose? : sql server replication

743


What are the differences between sql server and mysql.

760


How to write a query with a full outer join in ms sql server?

726


What is the command used to check locks in microsoft sql server?

721


How do triggers work?

694






Can you move the resources after pausing the node? : sql server database administration

773


How does using a separate hard drive for several database objects improves performance right away?

700


how many type of indexing in database?

732


How to test values returned by a subquery with the in operator?

880


What is service broker? : sql server database administration

743


How to delete multiple rows with one delete statement in ms sql server?

693


Which are the important points to note when multilanguage data is stored in a table?

683


How to modify an existing stored procedure in ms sql server?

742


Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1075


How you can change a cross join into an inner join?

719