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

how to determine the service pack currently installed on sql server? : Sql server database administration

934

Why use stored procedures in sql server?

979

What do you understand by replication in sql server? Mention the different types of replication in sql server.

911

Tell me about builtinadministrator?

970

How to write character string constants or literals in ms sql server?

980

Do you know hot add cpu in sql server 2008?

921

What do you mean by a dependent functionality in a build?

1090

What is data source document?

999

What are the limitations/drawbacks or ssrs 2008 r2?

137

What is SQL Azure Fabric?

110

What are parameterized reports? What are cascading parameters in ssrs reports?

156

What are the different authentication modes in sql server?

1077

what is difference between NULL and ISNULL in SQL Server 2008?

989

What is subquery? Explain the properties of a subquery?

946

What is the purpose of indexing?

1015