HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE

Answer Posted / raghuvir

Select *from Emp_table where salary=20000

will display all the employees who have salary 20000

Is This Answer Correct ?    30 Yes 26 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

540


How many levels of sp nesting are possible?

557


How many triggers are possible per table?

629


What is the difference between left and right outer join?

547


Is mysql the same as sql server?

515






what protocol both networks use? : Sql server database administration

542


Tell me what are the advantages of using stored procedures?

572


How to view existing indexes on an given table using sp_help?

597


Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

575


Explain the relational database management system (rdbms)?

528


What is the process of normalising?

592


How to find the version of sql server? : sql server database administration

631


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

544


Can you explain various data region available in ssrs with their use?

548


Why use identity in sql server?

568