Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yessi
Starting Member
2 Posts |
 Posted - 2006-03-27 : 21:13:05
|
| Hi guys....im new with database and just learn nowand sorry if my question is very absic with databasei have employees table and in that table i have column employeeId, managerID and amount.For example in that table i have filled the dataEmployeeID ManagerID AmountBob Sarah 500Sarah Richard 1000Richard Ryan 2000Ryan Allen 3000Allen Allen 500the problem is when i want to retrieve data for example i want to retrieve employeeID where amount <=100and when i execute this queryselect EmployeeID, Amount where Amount<=100it doesnt retrieve any data, if im not wrong...it should retrieve 5 rows based on that sample data that i had given above....Is that something that i missed?Any Help will be appreciated.....Best RegardsYessi |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-03-27 : 21:18:07
|
You missed out the FROM in your queryselect EmployeeID, Amount FROM employees where Amount<=100 You wanted employee with amount <= 100. But in the sample data all Employee's Amout is greater than 100 ! So 0 records return 
KHChoice is an illusion, created between those with power, and those without.Concordantly, while your first question may be the most pertinent, you may or may not realize it is also the most irrelevant |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
New with Database