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
What are the grouping functions?
What is compression - row-level and page-level compression?
When would you use it?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
Can I run multiple instances of sql server 2000 at the same time on one computer?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is the difference between varchar and nvarchar datatypes?
Do you know exporting and importing utility?
How can I add Reporting Services reports to my application?
What is dimension table? : sql server analysis services, ssas
Why use identity in sql server?
What does indexation mean?
What are the export options of ssrs?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What are the three different part of rdl file explain them?