Answer Posted / sannnnnnnnnnn
select max(sal) from emp where sal<(select max(sal) from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can I track the changes or identify the latest insert-update-delete from a table?
What is user defined datatypes and when you should go for them?
What is use of except clause? How it differs from not in clause?
What action plan is preferred if sql server is not responding?
When would you use sql joins?
Mention the command used to rename the database.
What are the options which must be set to allow the usage of optimistic models?
What are page splits?
what is the main function of a query parameter?
Explain nested join?
What happens on checkpoint?
How to copy the tables, schema and views from one sql server to another?
Tell me what is difference between view and materialized view?
What is a rownum?
Tell me about normalization in DBMS.