Select *from Emp_table where salary=20000 will display all the employees

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

Question Posted / raghuvir

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

Please Help Members By Posting Answers For Below Questions

What are the benefits of filtered indexes?

979

What is the difference between createstatement and preparedstatement?

884

What is a rownum?

899

what are different types of raid configurations? : Sql server database administration

995

What is the definition for sql server 2000?

1044

Explain datetimeoffset data type in sal server 2008?

854

What is ssrs?

117

What is dbcc?

1086

Name few of the dcl commands in sql?

953

List the data types available in mssql?

960

What is merge statement?

1021

how to use DTS package in 2000,2005,2008 in sql server

1791

What is coalesce and check constraint in sql server?

1048

How to receive returning result from a query?

1040

What is the web service used for reporting services?

115