Home » RDBMS Server » Server Administration » What is the Query?
What is the Query? [message #372402] Fri, 09 February 2001 07:39 Go to next message
Gayathri
Messages: 19
Registered: February 2001
Junior Member
consider a table test2 having the columns base_no and fld1,(totally 2 columns)
write a query to give the foll. output:

base_no fld1
------- ----
00001 a
00002 b
00003 a
00004 c
00005 b

Report message to a moderator

Re: What is the Query? [message #372406 is a reply to message #372402] Fri, 09 February 2001 08:49 Go to previous messageGo to next message
John R
Messages: 156
Registered: March 2000
Senior Member
Yup, thats an easy one.
Next....

Report message to a moderator

Re: What is the Query? [message #372424 is a reply to message #372402] Mon, 12 February 2001 05:04 Go to previous message
geetha
Messages: 20
Registered: August 2000
Junior Member
select base_no,fld1 from test2;

Report message to a moderator

Previous Topic: how do you set a fixed character length
Next Topic: syntax problems using sqlplus in msdos prompt
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 01 05:13:08 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.