17-10-12, 02:11 PM
كاتب الموضوع : AhmedEssawy
الاستعلام عن الموظفين بشرط ان يتجاوز ID رقم خمسه
كود :
[color=#990000]1[/color][color=black]>[/color][FONT=Courier New]
[color=#990000]2[/color]> select * from [color=black]employee[/color]
[color=#990000]3[/color][color=black]> GO[/color]
[color=black]ID name salary start_date city region[/color]
[color=black]----------- ---------- ----------- ----------------------- ---------- ------[/color]
[color=#990000]1 [/color][color=black]Jason [/color][color=#990000]40420 1994[/color][color=black]-[/color][color=#990000]02[/color][color=black]-[/color][color=#990000]01 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]New York W[/color]
[color=#990000]2 [/color][color=black]Robert [/color][color=#990000]14420 1995[/color][color=black]-[/color][color=#990000]01[/color][color=black]-[/color][color=#990000]02 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Vancouver N[/color]
[color=#990000]3 [/color][color=black]Celia [/color][color=#990000]24020 1996[/color][color=black]-[/color][color=#990000]12[/color][color=black]-[/color][color=#990000]03 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Toronto W[/color]
[color=#990000]4 [/color][color=black]Linda [/color][color=#990000]40620 1997[/color][color=black]-[/color][color=#990000]11[/color][color=black]-[/color][color=#990000]04 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]New York N[/color]
[color=#990000]5 [/color][color=black]David [/color][color=#990000]80026 1998[/color][color=black]-[/color][color=#990000]10[/color][color=black]-[/color][color=#990000]05 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Vancouver W[/color]
[color=#990000]6 [/color][color=black]James [/color][color=#990000]70060 1999[/color][color=black]-[/color][color=#990000]09[/color][color=black]-[/color][color=#990000]06 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Toronto N[/color]
[color=#990000]7 [/color][color=black]Alison [/color][color=#990000]90620 2000[/color][color=black]-[/color][color=#990000]08[/color][color=black]-[/color][color=#990000]07 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]New York W[/color]
[color=#990000]8 [/color][color=black]Chris [/color][color=#990000]26020 2001[/color][color=black]-[/color][color=#990000]07[/color][color=black]-[/color][color=#990000]08 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Vancouver N[/color]
[color=#990000]9 [/color][color=black]Mary [/color][color=#990000]60020 2002[/color][color=black]-[/color][color=#990000]06[/color][color=black]-[/color][color=#990000]09 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Toronto W[/color]
[color=black]([/color][color=#990000]9 [/color][color=black]rows affected)[/color]
[color=#990000]1[/color][color=black]>[/color]
[color=#990000]2[/color][color=black]> --Not less than.[/color]
[color=#990000]3[/color][color=black]>[/color]
[color=#990000]4[/color]> select * from employee where [color=black]id !< [/color][color=#990000]5[/color]
[color=#990000]5[/color][color=black]> GO[/color]
[color=black]ID name salary start_date city region[/color]
[color=black]----------- ---------- ----------- ----------------------- ---------- ------[/color]
[color=#990000]5 [/color][color=black]David [/color][color=#990000]80026 1998[/color][color=black]-[/color][color=#990000]10[/color][color=black]-[/color][color=#990000]05 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Vancouver W[/color]
[color=#990000]6 [/color][color=black]James [/color][color=#990000]70060 1999[/color][color=black]-[/color][color=#990000]09[/color][color=black]-[/color][color=#990000]06 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Toronto N[/color]
[color=#990000]7 [/color][color=black]Alison [/color][color=#990000]90620 2000[/color][color=black]-[/color][color=#990000]08[/color][color=black]-[/color][color=#990000]07 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]New York W[/color]
[color=#990000]8 [/color][color=black]Chris [/color][color=#990000]26020 2001[/color][color=black]-[/color][color=#990000]07[/color][color=black]-[/color][color=#990000]08 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Vancouver N[/color]
[color=#990000]9 [/color][color=black]Mary [/color][color=#990000]60020 2002[/color][color=black]-[/color][color=#990000]06[/color][color=black]-[/color][color=#990000]09 00[/color][color=black]:[/color][color=#990000]00[/color][color=black]:[/color][color=#990000]00.000 [/color][color=black]Toronto W[/color]
[color=black]([/color][color=#990000]5 [/color][color=black]rows affected)[/color][/FONT]