Answer Posted / amruta dash
select max(salary) from tblname where salary not in (select
max(salary) from tblname);
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
State a few properties of relational databases?
1 01 101 01010
Can I disable or restrict ssrs export formats (rendering formats)?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
what are the Prerequisites for Replication?
How do we know if any query is retrieving a large amount of data or very little data?
How do I find the size of a sql server database?
what are constraints? Explain different types of constraints? : Sql server database administration
What is 1nf 2nf and 3nf?
Which are the olap features?
What do you mean by recursive stored procedure?
How to assign new column names in a view?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
How to modify an existing user defined function?
What is the filtered index?