Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-11-29 : 08:19:03
|
| jagadeesh writes "1)I have a simple question how can i select last row of the table?2)How can i find out how many values are reentered in to the table and how many times entered?" |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-11-29 : 08:38:40
|
| 1) Define "last" please.2) Define "reentered" please.Peter LarssonHelsingborg, Sweden |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-11-29 : 08:39:28
|
| 1. Select Top 1 * from Tbl order by SomeCol Desc2. More explaination please.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-11-29 : 09:54:52
|
quote:
Originally posted by AskSQLTeam
jagadeesh writes "1)I have a simple question how can i select last row of the table?2)How can i find out how many values are reentered in to the table and how many times entered?"
How was the Interview?You need to learn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.aspMadhivananFailing to plan is Planning to fail |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-11-29 : 19:23:56
|
perhaps "reentered" means updated?
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-01 : 03:00:42
|
quote:
Originally posted by jezemine
perhaps "reentered" means updated?
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org
Yes it isMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Re:select, insert