Disply the dname wise maximum salary
Answer Posted / gyana ranjan behera
SELECT DNAME,MAX(SAL) FROM DEPARTMANT_TABLE GROUP BY DNAME
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain how to get the first 100 rows from the flat file into the target?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
After the complete generation of a report who will test the report and who will analyze it?
What are session timeout and application timeout? Where we have to do this process?
What is prompt types of prompts?use of prompts syntax of prompt?
Explain can report net connect multiple datasource at a time in report creation time?
Explain what is partitioning? What are the types of partitioning?
How to performance tune reports?
Ist the schema that a data warehouse system can implements.
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Explain differences between star and snowflake schemas?
What are the advantages of cold fusion?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?