write sql program to get the detail of student in a class?
Answer Posted / muruga nandhini.p
create table student
(
roll_no int,
name varchar(20),
class int,
address varchar(50),
phone int
)
++++++++++++++++run select than press f5
insert into student values(1,'Bhagwat',10,'Mathura',9268450493)
+++++++++++++run select than press f5
select * from student where roll_no=1
+++++++++++++++++++++++++++run select than press f5
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Can you please explain the difference between function and stored procedure?
Explain what is the purpose of sql profiler in sql server?
Which data type columns are the best candidates for full-text indexing?
What is extended stored procedures?
What is difference between rownum and row_number?
Explain how would you store your query in an SSRS report or a Database server?
How to sort query output in descending order in ms sql server?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
How many types of keys are there?
What is the difference between a local and a global temporary table?
Tell me can we use custom code in ssrs?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What are the different acid properties?
Does the order of columns in update statements matter?
How to execute a sql statement using mssql_query()?