Interested to Buy Any Domain ? << Click Here >> for more details...
wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records
- 19 Answers
- 29256 Views
- I also Faced
- E-Mail Answers
Answer Posted / teja
select * from employee where emp_id in
(select top 3 emp_id from employee order by emp_id DESC)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
How to get the query of a table in sql server?
Write a SQL query in order to merge two different columns into single column?
What is a transact-sql statement batch in ms sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
What is the tcp/ip port on which sql server runs?
How self join is different from outer join?
What is bcnf normalization form?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is a non clustered primary key?
What is normalization? Explain different forms of normalization?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What happens if null values are involved in bitwise operations?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Tell me what is difference between view and materialized view?
