Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / ramlakhan

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

Explain about builtinadministrator?

0 Answers  

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

What is cte (common table expression)?

0 Answers  

Can a database be shrunk to 0 bytes, if not, why?

0 Answers  

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,




Why SQL Agent is used?

0 Answers   Abacus,

What is an expensive query?

0 Answers  

What is the log shipping?

0 Answers  

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

How to get max 100 values from sql server

7 Answers  

in how many ways we can use count()

2 Answers  

What is a partitioned view?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories