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

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

Question Posted / ramlakhan

2 Answers
5218 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / saurav kumar

table: employee; column name: lastname

select * from employee where lastname like '%n'

Is This Answer Correct ?

29 Yes

0 No

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

Answer / anshu sharma

SELECT * FROM TABLE_NAME WHERE EMP_LASTNAME LIKE 'N%'

Is This Answer Correct ?

5 Yes

10 No

Post New Answer

More SQL Server Interview Questions

What is BCP? When do we use it?

2 Answers

What are different types of table joins?

0 Answers

What is difference between global temporary tables and local temporary tables?

0 Answers Tech Mahindra,

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

0 Answers

What are the advantages of using sql server over ms access or why should one use sql instead of ms access

2 Answers CMS, Impetus,

What is the use of floor function in sql server?

0 Answers

Do you know what is a trace frag? Where do we use it?

0 Answers

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers B-Ways TecnoSoft,

Explain the concept of view and Types of views in SQL server?

0 Answers HCL,

Explain some DBCC commands?

6 Answers

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers Accenture, IBM, Marlabs,

Give the query of getting last two records from the table in SQL SERVER?

0 Answers Petranics Solutions,

For more SQL Server Interview Questions Click Here