sql queries

Question

Hii I have 1 table where doctr_namemobileSource_name r fields And in 2'nd table Lab_namemobilesource_name r fields. Now i want show the recently added doctor_name and lab_name in a Region. And Also what is region in sql and when do we use them. Thanks in advance.

Neha Sharma · Answer

you can do this by declaration of date after where clause in sql query

sathish kumar · Answer

if u have row id column( not null) with tat u can sipmly get it by using select max(RowId) from tablename

Pradip Pandey · Answer

Refer this link to get more about region in sql http://blogs.msdn.com/b/sreekarm/archive/2008/12/28/grouping-sets-in-sql-server-2008.aspx Hope it will help.