How to find out name of all employees who has salary less
than 200 Rs.?
Answer Posted / jay
select * from Employees where Salary <200
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
If a stored procedure is taking a table data type, how it looks?
List the ways in which dynamic sql can be executed?
How to test subquery results with the exists operator?
How to bind a view to the schema of the underlying tables?
What is the use of “join” in sql server?
What are .mdf files?
What is the importance of three tier architecture?
Distinguish between nested subquery and correlated subquery?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
Why do we need different type of parameter?
What is history table in sql server?
What according to you is the difference between mysql and sql server performance?
What are acid properties of transaction?
What is compound operators?