Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you find value of first column before inserting value
into the second column in the same table for checking that second column must have different value than first column.

Answer Posted / ankita upadhyay

by using lookup function
syntax-
LOOKUP(lookup_value,lookup_vector);

lookup_value-contain the name of field(like id) about which you have to find info

lookup_vector-contain a range of row or column which contain value of respective ids

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is tcl in sql server?

1131


What is difference between views and tables?

1019


What is report snapshot?

163


How the authentication mode can be changed?

1137


Explain the advantages of merge replication?

955


What is indexing explain it with an example?

1016


What are the tool windows in sql server management studio? : sql server management studio

1084


What is normalization and what are the advantages of it?

988


How connect excel to sql server?

1002


Why truncate is ddl command?

1069


Can you explain full-text query in sql server?

1016


How to connect to a sql server using odbc_connect()?

1161


What is the maximum size of column in sql server?

896


What is subquery? Explain the properties of a subquery?

991


How do I find query history in sql server?

949