How to find out name of all employees who has salary less
than 200 Rs.?
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 table value parameters (tvp)?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What is a domain constraint give an example?
Do you know nested transaction?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Can we linked SharePoint to a SQL database?
what is the maximum size of a row? : Sql server database administration
What is a transactions?
How do you create an execution plan?
what is checksum in sql server.........???
How to use subqueries with the exists operators in ms sql server?
How do I know if localdb is running?
What is the use of sign function?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
Which sql server table is used to hold the stored procedure script?