Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out name of all employees who has salary less
than 200 Rs.?
- 8 Answers
- 10750 Views
- I also Faced
- E-Mail Answers
Answer Posted / manu
select emp<e name field>,sal<Sal field> from employees <Table name>
where sal<Sal field> < 200
Note: Field = Table column name......
enjoy... this is simple query
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How to list all login names on the ms sql server?
Do I need a report server to run reports in my application?
What is transaction server isolation?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are database states in ms sql server?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is constraints and its types?
Can you edit the .rdl code associated with a linked report?
What is plan freezing?
Can we call future method from queueable?
Mention the 3 ways to get a count of the number of records in a table.
List few advantages of stored procedure.
explain how to create a new schema in a database? : Sql server database administration
