Interested to Buy Any Domain ? << Click Here >> for more details...
how to get max salary with employee number by using one select
query and max function ??
- 3 Answers
- 8681 Views
- Genpact, I also Faced
- E-Mail Answers
Answer Posted / suresh jp
select emp_no,max(salary) over() from table_employee;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the differences between having and where clause.
What new changes are being made in SQL Server?
Can we use where and having clause together?
Tell me what is sql profiler?
Explain the etl (extraction, transformation, and loading)?
What is de-normalization in sql database administration? Give examples?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is bcp? When does it used?
Explain boyce and codd normal form(bcnf)?
How to write character string constants or literals in ms sql server?
How to create dbo table in sql server?
what is hash nonclustered index
What is query parameter in ssrs?
What is report snapshot?
What is normalization and its types?
