SELECT * FROM TABLE_NAME WHERE EMP

Selet all the data from table where last name is n of
employee

Question Posted / anshu sharma

2 Answers
5324 Views
I also Faced
E-Mail Answers

Answer Posted / anshu sharma

SELECT * FROM TABLE_NAME WHERE EMP_LASTNAME LIKE 'N%'

Is This Answer Correct ?

5 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger explain with program?

984

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1121

How to convert binary strings into integers in ms sql server?

1031

which backup strategy you are following at ur company

2148

Which sql server is best?

996

What is store procedure? How do they work? When do you use?

944

Sql server reporting services vs. Crystal reports.

132

What are exact numeric data types in ms sql server?

1078

What do you understand by intent locks?

1012

what is an extended stored procedure? : Sql server database administration

1056

what is a join and explain different types of joins? : Sql server database administration

960

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1064

How to create a new table in a given schema?

1189

How to see existing views in ms sql server?

1045

Explain Capacity planning to create a database? and how to monitor it?

4204