Answer Posted / m.s.patil
select max(sal) from t1 where sal not in (27777);
27777 is max salary in table
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain the properties of sub-query in sql server?
What is blocking and how would you troubleshoot it? : sql server database administration
How to connect sql server management studio express to sql server 2005 express?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is difference between delete and truncate commands?
What do you understand by intent locks?
what is difference between view and Dip.
What is the purpose of the master database?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
What are the operating modes in which database mirroring runs?
What is entity data services?
What are the advantages of having an index on the sql server?
What do you do in data exploration
Define msdb database?