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

Answer Posted / praveen kumar.dandu

select ename from emp where sal<200

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is row_number () and partition by in sql server?

532


How to find the second highest salary of an employee?

611


Name and describe few console utilities for ssrs?

249


Difference between 2NF &3NF ?

686


Can select statements be used on views in ms sql server?

598






Explain tablesample?

559


What are audit control procedures?

600


How use inner join in sql server?

623


How to join two tables in a single query in ms sql server?

552


what are different types of raid configurations? : Sql server database administration

499


What is primary key, unique key, and foreign key?

551


How can you fetch alternate records from a table?

555


Explain syntax for disabling triggers?

529


Suggest a method of joining two tables.

618


What are horizontal and vertical scaling?

148