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

write an SQL query to list the employees who joined in the month of January?

1666

What is an example of a foreign key?

964

What function does a database engine serve in the sql server?

1023

Explain the concept of recursive stored procedure.

919

What is nolock hint in sql server 2008

1109

What is transaction server explicit transaction?

1016

How can you hide the sql server instances?

1007

List out different types of normalizations in sql server and explain each of them?

914

What is the maximum number of index per table?

1057

What is equi join with example?

1100

What is not null constraint?

1094

Where sql server user names and passwords are stored in sql server? : sql server database administration

1035

What is use of except clause? How it differs from not in clause?

1006

What is the main difference between ‘between’ and ‘in’ condition operators?

1169

what are the Prerequisites for Replication?

11326