write a query to Find the Maximun second value in table?
Answer Posted / tulasi
select * from emp x where 2=(select count(distinct sal)
from emp y where x.sal<=y.sal);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
explain the term ‘attribute’?
What are the main components of a database system?
Describe the purposes and advantages stored procedure?
Have you written applications to retrieve stored images in a table?
Explain the term specialization.
Briefly describe the three types of sql commands.
What is tabular form?
Can we store images in database?
Mention a query to calculate the even and odd records from a table
What is primary key in database?
How to schedule ssas database backup
What are new features postgre 9.1?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
What is a database in healthcare?
What is normal form in dbms?