Interested to Buy Any Domain ? << Click Here >> for more details...
write a query for the fifth highest salary?
- 17 Answers
- 24503 Views
- IBM, Matlabs, Ramco, I also Faced
- E-Mail Answers
Answer Posted / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
Differentiate between delete and truncate table?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
What is database schema name?
Why do we need distributed database?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
Explain entity set?
Is data lake a database?
What are different types of data models available? Explain with example?
What do you mean by cluster and non cluster index?
A lowest level of security by most RDBMS is
How to do Stored procedure testing? Who does this testing (Developer or tester)?
What is a reference table in database?
What are the concurrency problems a database faces?
What is the use of graph database?
Explain inner and outer joins with examples.
