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 is a traditional network library for sql servers? : Sql server database administration

963

How to include text values in sql statements?

1047

What is explicit cursors?

1082

What is model database in sql server?

1058

Please explain what is “asynchronous” communication in sql server service broker?

943

What is the difference between TRUNCATE and DROP?

1148

What are the export options of ssrs?

173

What is the fillfactor concept in indexes?

994

What is create command?

976

What are the different authentication modes in sql server? How can it be changed?

1099

What are the character string functions supported by sql server 2005?

1021

What is use of except clause?

1095

What is isolation levels?

1037

What is difference between join and natural join?

980

How to create a large table with random data for index testing in ms sql server?

1036