how to dispaly a particular row details from a given table
Answers were Sorted based on User's Feedback
Answer / karthick.r
the query to display a particular record for the emp'v4290'
is given below
select * from employee where empid="v4290";
in this eg employee is the table-name and v4290 is the value
for the attribute empid. where is the clause to fetch the
record from the backend database table
Is This Answer Correct ? | 3 Yes | 0 No |
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
How do you identify a foreign key?
hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
what is cluster and nin-cluster index?
What are the types of normalization?
What is user defined datatypes and when you should go for them?
Why normalization is used?
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.
What is user-defined function?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the difference between temp table and table variable?