Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.?

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


Please Help Members By Posting Answers For Below Questions

What is table value parameters (tvp)?

1103


Why do we use sql limitations? Which constraints can we use while making a database in sql?

1080


What is a domain constraint give an example?

1049


Do you know nested transaction?

963


What is perspective, have you ever created perspective? : sql server analysis services, ssas

918


Can we linked SharePoint to a SQL database?

1032


what is the maximum size of a row? : Sql server database administration

1016


What is a transactions?

1042


How do you create an execution plan?

952


what is checksum in sql server.........???

1690


How to use subqueries with the exists operators in ms sql server?

1122


How do I know if localdb is running?

955


What is the use of sign function?

1126


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

1684


Which sql server table is used to hold the stored procedure script?

950